The Business Master (3rd Edition)

home *** CD-ROM | disk | FTP | other *** search

/ The Business Master (3rd Edition) / The Business Master (3rd Edition).iso / files / busition / dayosup2 / dayoscd.exe / DAYOSC.DOC < prev next >

Wrap

Text File | 1992-06-25 | 389.8 KB | 4,968 lines

╔════════════════════════════════════════════════════════════════════════════╗ ║ ║ ║ ██▄█████████▄ ▄█▄ ███ ███ ▄███████████▄ ║ ║ ███ ███ ▄█████▄ ███▄ ▄███ ███ ███ ║ ║ ███ ███ ███ ███ ▀███ ███▀ ███ ███ ║ ║ ███ ███ ███ ███ █████ ███ ███ ║ ║ ███ ███ ▄███████████▄ ███ ███ ███ ║ ║ ███ ███ ███ ███ ███ ███ ███ ║ ║ ██▀█████████▀ ███ ███ ███ ▀███████████▀ ║ ║ ║ ║ ██████ ██ ██ ██▄███ ██▄███ ▄████▄ ██▄███ ██████ ║ ║ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ║ ║ ██████ ██ ██ ██████ ██████ ██ ██ ██████ ██ ║ ║ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ║ ║ ██████ ██████ ██ ██ ▀████▀ ██ ▀██ ██ ║ ║ ║ ║ ██████ █ ██ ██ ██████ ║ ║ ██ ███ ██ ██ ██ ║ ║ ██ ██ ██ ██ ██ ██████ ║ ║ ██ ███████ ██ ██ ██ ║ ║ ██████ ██ ██ ██████ ██████ ██████ ║ ║ ║ ║ ██ ██ █ ██ ██ █ ██████ █████ ██ ██ █████ ██ ██ ██████ ║ ║ ███ ███ ███ ███ ██ ███ ██ ██ ███ ███ ██ ███ ██ ██ ║ ║ ████████ ██ ██ ██████ ██ ██ ██ ███ ████ ███████ ████ ██████ ██ ║ ║ ██ ██ ██ ███████ ██ ███ ███████ ██ ██ ██ ██ █ ██ ██ ██ ███ ██ ║ ║ ██ ██ ██ ██ ██ ██ ██ ██ ██████ █████ ██ ██ █████ ██ ██ ██ ║ ║ ║ ║ ██████ ██ ██ ██████ ██████ █████ ██ ██ ║ ║ ██ ██ ██ ██ ██ ██ ███ ███ ║ ║ ██████ ████ ██████ ██ ████ ███████ ║ ║ ██ ██ ██ ██ ██ ██ █ ██ ║ ║ ██████ ██ ██████ ██ █████ ██ ██ ║ ║ ║ ║ Copyright (c) 1991 - 1992, TJS LAB Inc. ║ ║ 5104 North Orange Blossom Trail, Ste 200, Orlando, FL 32810 ║ ║ ║ ║ ██████ ▀███████████▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▐█▌ S H N ║ ║ ▀ ██ ▀ ████ ▀▀▀▀▀███████████████████████████▌ O A E ║ ║ ██ ██ ▄███▄ ▀████▀▀ ▀████████████ F R T ║ ║ ██ ██ ██ ▀ ▀▀ ███████████ T D W ║ ║ ██ ▄ ██ ▀███▄ Specializing In ▐█████████▌ W W O ║ ║ ▀███▀ ▄ ██ MicroComputer & Network ██████████ A A R ║ ║ ▀███▀ Solutions & █████*████▌ R R K ║ ║ Applications ▐███████████ E E S ║ ║ ▀██ █ ▀█▄███▄ ┌─┐ ┌─┐ ███████████▌ ║ ║ ██ █▀█ ██ ██ ┌╧─╧┐ ┌─┐ ┌╧─╧┐ ████▀ ▀███ Custom: ║ ║ ██ ▄█ █▄ █████ └───╜ ┌╧─╧┐ └───╜ ███ ██▌ Programs ║ ║ ██ ██▄██ ██ ██ ▐▀▌ └───╜ ▐▀▌ ███▄▄███ Reports ║ ║ ████ ▄█ █▄ █▀███▀ █████ ▐▀▌ █████ ▀█████▌ Routines ║ ║ █████ ▀▀▀█ Forms ║ ║ Incorporated █ ║ ║ ▄▄▄▄▀ ║ ╠════════════════════════════════════════════════════════════════════════════╣ ║ Support: (407) 291-3960 Sales: 292-4708 Fax: 295-2171 BBS: 292-4921 ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO SC, Copyright(c) 1992 TJS LAB, INC. ■ SOFTWARE SUPPORT POLICY 1. TJS LAB does not support users of unregistered DAYO products with the exception of installation questions. 2. Support (included with registration) remains in effect for 3 months after date of registration or purchase. 3. Support is available through the following methods: - Limited Phone Support: (407) 291-3960 9am to 5pm M-F - U.S. Mail: TJS LAB, Inc., PO Box 585366, Orlando, FL 32858-5366 - Compuserve Easyplex: 76367,1401 4. Any errors ("bugs or features') in the program will be corrected and the 'fix' sent promptly (via modem if possible). DAYO SC, Copyright(c) 1992 TJS LAB, INC. Table of Contents Page Subject ──── ────────────────────────────────────────────────────────── 1......INTRODUCTION 2......COPYRIGHT/LICENSE 2......DISCLAIMER 2......REQUIREMENTS 2......SETUP 3......DATA (DATABASE) FLOW 4......DAYO SC 'RULES' 5......MAIN MENU 6...... EXIT 6...... EDIT CURRENT SUPPORT CALL RECORD 7......SELECT INCOMING PHONE CALL 7......CLOSE CURRENT SUPPORT CALL 8......EDIT SUPPORT CALL/INCIDENT NOTES 8......RUN MENU 9...... EDIT MENU RECORD 9...... ADD MENU RECORD 10......REPORTS 10...... REPORTS LISTING 11...... PRINTER SETUP/DRIVER 11...... PRINTER DRIVER OPTIONS 12...... CHANGE DEFAULT PRINTER 13...... FULL SCREEN EDIT - PRINTER DRIVER 13...... PRINTER DRIVER DATABASE FIELD DEFINITIONS 14...... PIN LIST 18...... PIN LABELS 19...... PIN PHONE LIST 20...... EXPANDED PIN REPORT 21...... PIN USAGE & HISTORY REPORT 22...... OPEN INCOMING PHONE LOG LISTING 22...... OPEN SUPPORT CALLS REPORT 23...... CALL LOG (HISTORY) REPORT 23...... CATEGORY #1 PROBLEM LISTING 24...... CATEGORY #2 PROBLEM LISTING 24...... RESOLUTION LISTING 24...... CATEGORY #1 PROBLEM LISTING 25...... CUSTOMER BILL TO ADDRESS LABELS 26...... CONFIGURATION STATUS REPORT 26...... EXAMPLE OF A CONFIGURATION STATUS REPORT 27...... CALCULATOR 27...... VIEW REPORTS ON SCREEN 29...... REPORT VIEWING SCREEN 30......BROWSE OPEN SUPPORT CALLS/RECORDS 31...... FULL SCREEN EDIT - OPEN SUPPORT CALL RECORD 32...... EDIT SUPPORT CALL/INCIDENT NOTES DAYO SC, Copyright(c) 1992 TJS LAB, INC. Table of Contents Page Subject ──── ────────────────────────────────────────────────────────── 33...... ADD SUPPORT CALL/INCIDENT RECORD 33...... FIND PIN RECORD WHILE CREATING A NEW SUPPORT CALL RECORD 34...... FAST FIND PIN WHILE CREATING A NEW SUPPORT CALL RECORD 35...... FIND INCIDENT/SUPPORT CALL RECORD 36......BROWSE PIN DATABASE 37...... FULL SCREEN EDIT - PIN RECORD 37...... FIND PIN RECORD 38...... FAST FIND PIN 39...... EDIT PIN NOTES 40......BROWSE HISTORY OF SUPPORT CALLS DATABASE 41...... FULL SCREEN EDIT - HISTORY SUPPORT CALL/INCIDENT RECORD 42...... EDIT HISTORY SUPPORT CALL/INCIDENT NOTES 42...... FIND HISTORY SUPPORT CALL/INCIDENT RECORD 43......BROWSE CUSTOMERS 44...... ADD A NEW RECORD - FULL SCREEN EDIT 44...... FIND CUSTOMER RECORD 46......SUPERVISOR OPTIONS (CONFIGURATION) 46...... CONFIGURATION LISTING 47...... COMPANY NAME 47...... COMPANY ADDRESS 47...... COMPANY TELEPHONE 47...... LAST REFERENCE NUMBER 48...... ALLOW CUSTOMER ADD 48...... CUSTOMER DATABASE LOCATION/DIRECTORY 49...... 'RAW' PHONE LOG DATABASE LOCATION/DIRECTORY 49...... CURRENT DIRECTORY DATABASE LOCATION 50...... BROWSE PROBLEM CATEGORY #1 50...... FULL SCREEN EDIT - CATEGORY 2 RECORD 51...... BROWSE PROBLEM CATEGORY #2 51...... FULL SCREEN EDIT - CATEGORY 2 RECORD 52...... BROWSE RESOLUTION DATABASE 52...... FULL SCREEN EDIT - RESOLUTION RECORD 53...... EDIT SERIAL NUMBER CODES 53...... EDIT NOTES - SCREEN MODE: 25, 43 (EGA), or 50 (VGA) LINES 54...... ASSIGN PIN BLOCKS/NUMBERS 55...... BROWSE 'RAW' PHONE LOG DATABASE 56...... FULL SCREEN EDIT - VRU/LOG.DBF RECORD 57...... DEFAULT EXCLUDED MAIN MENU OPTIONS (USED WITH PASSWORDS) 57...... USE PASSWORDS 58...... PASSWORDS MAINTENANCE 58...... EDIT/ADD PASSWORD 59...... NOVELL NETWORK & PASSWORDS 60...... GLOBAL PACK & REINDEX DAYO SC, Copyright(c) 1992 TJS LAB, INC. Table of Contents Page Subject ──── ────────────────────────────────────────────────────────── 61...... MISCELLANEOUS ROUTINES 61...... MISC ROUTINES MENU: 62...... APPEND FROM 64...... BROWSE DATABASES 66...... COPY (.DBF) TO 68...... CREATE DATABASE 70...... DELETE RECORDS 71...... ERASE FILE 71...... EXIT TO DOS 72...... INDEX A DATABASE 73...... LIST FIELDS 76...... MODIFY DATABASE 77...... PACK DATABASE 78...... RECALL RECORDS 78...... RETURN TO MENU 78...... RUN (DOS COMMAND) 79...... SIMPLE EDITOR 80...... SORT DATABASE 81...... TYPE (PRINT) FILE 82...... ZAP DATABASE 84...... SCREEN FONTS 84...... SYSTEM 85...... REPORT PRINTER PORT 85...... AUTOMATIC DAILY INDEXING 85...... COLOR MONITOR 85...... COLOR INTENSITY 86...... CREDITS 87......REINDEX ALL DATABASES 87......AVAILABLE MEMORY 88......HELP SCREENS 89...... EXPANDED HELP 90...... USER DEFINED & INPUTTED HELP SCREENS/MESSAGES 91...... VIEW DOCUMENTATION ON SCREEN 92......DATABASE STRUCTURES 99......DATA DICTIONARY 104......TJS 'COMPUTER' LAB INC DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 1 ■ INTRODUCTION DAYO Support Call Management System (SC) gives you the platform for managing all your support and/or service calls. It is by default a multiuser system, allowing almost unlimited numbers of users to have the ability to simultaneously access the same data on a PC based LAN/Network, ie: Novell (tm) and LANtastic (tm). Options, features and reports include: Printer Setup, PIN List, PIN Labels, PIN Phone List, PIN Expanded Report, PIN Usage/History Report, Open Call Log List, Daily Call Log Report, Incident/Support Call Log Report, Category #1/Problem List, Category #2/Problem List, Resolutions List, Customer List, Customer Labels, Configuration Status Report, Calculator, View Reports On Screen, Company Name, Company Address, Company Telephone, Last Reference Number, Allow Customer Add, Customer Location, Phone Log Location, Current Directory, Browse Category #1, Browse Category #2, Browse Resolutions, Serial Number Codes, Notes Screen Size, Assign PIN Blocks, Browse Phone Log, Default Excluded Options, Use Passwords, Passwords Maintenance/Browse, Global Pack & Reindex, Miscellaneous Database Routines, Screen Fonts, System Statistics, Report Printer Port, Auto Daily Indexing, Color or Mono Monitor, and High Intensity Color Setting. Other DAYO Products: DAYO Inventory Inventory Control, Vendors, Purchasing, Receiving DAYO Quotes Sales Quoting System DAYO Price Books Special pricing for your customers as well as a wide range of product catalogs/reports DAYO AR Accounts Receivable DAYO AP Accounts Payable DAYO EOP End Of Period Posting DAYO MRP Bill of Materials, Ship Orders DAYO Job Costing Job/Work Order/Project Costing System DAYO Smart Reports A variety of reports pertaining to the above modules DAYO Payroll U.S. Payroll DAYO Sales Mgmt Quotes, Calendar, Price Books and Contacts System DAYO Report Writer Relational Report (tm) Writer and many more... DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 2 ■ COPYRIGHT/LICENSE This manual and software is copyrighted with all rights reserved by TJS LAB. No copying of this manual or software is authorized without the prior written consent of TJS LAB. An exception to this rule is the making of backup copies of registered software disks. No RESALE of any part of the source codes is authorized without the prior written consent of TJS LAB. TJS LAB retains all rights to DAYO POS software, documentation, and source codes. Authorization to distribute Demonstration Versions is granted. ■ DISCLAIMER No warrant is made that this software will work in all environments, or with all resident programs and hardware configurations. TJS LAB has tested this software in many environments and found it to perform as expected, however, this software is licensed "AS IS". TJS LAB will not be liable for any damage done to your data, hardware, and/or software systems as a result of using DAYO SC. ■ REQUIREMENTS IBM Compatible Computer with at least 20 megabytes of free disk space (less required for Lap Tops). An AT class CPU is highly recommended (286 or better). 640k base RAM with 520k free after DOS (and Networks) loaded DOS 3.3 or above Printer, preferably an HP Laser Printer (or compatible, all/any types), but a Dot Matrix will be fine. ■ SETUP To setup DAYO SC, use the SETUP program supplied on the MENU or Update & Conversion diskette, or copy the contents of the DAYO SC floppy disks into a directory on your hard disk (ie: \DAYOSC), then 'uncompress' (ie: PKunzip ) them. When running DAYOSC for the first time, it will create all the database, index, and configuration files it requires for operation. If other DAYO modules are being used, be sure to enter the location of these databases into the DAYO SC configuration. DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 3 ■ DATA (DATABASE) FLOW ╔═══════════════╗ ╔══════════════╗ ║ Incoming ║ ║ Add (Ctrl N) ║ ║ Support Calls ║ ║ Support Call ║ ╚═══════════════╝ ║ or Incident ║ │ ╚══════════════╝ │ │ │ │ │ │ │ Add Record │ └────────┬─────────┘ │ ╔════════════════╗ │<─────────────────── ║ PIN ║ │ ║ Personal ║ │ ║ Identification ║ ╔══════════╗ │ ║ Number ║ ║ Customer ║ ──────────────────>│ ╚════════════════╝ ╚══════════╝ │ │ │ │ │ ╔═══════════════╗ ║ Open ║ Maintenance/Edit ║ Support Calls ║ Support Call/Incident ║ & Incidents ║ ie: record problem and resolution ╚═══════════════╝ │ │ │ Close Support Call/Incident │ │ ╔═══════════════╗ ║ History of ║ ║ Support Calls ║ ║ & Incidents ║ ╚═══════════════╝ DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 4 ■ DAYO SC 'RULES' Customers records are for accounting uses. A customer record may have many Personal Identification Number (PIN) records. You can not edit a customer record, but you can elect to be able to add new records. Every support call or incident must be assigned to a valid PIN. 'Incoming' support calls are only available to Voice Response Units (VRUs), and usually take some customization by TJS LAB, Inc. Support call records will be created (when you don't have a VRU), by pressing Ctrl N while in the browse routine of Open Support Calls (Alt O). Support calls/incidents stay open until you close them! A valid resolution code must be selected before you can close a call/incident. The first 5 digits of the PIN represent a single digit TYPE code, a 2 digit Month and a 2 digit Year code (date PIN was created). The right 6 digits of the PIN represent a numeric counter. The serial number is actually the PIN, with the 1st 5 digits encrypted. The serial number can be used on contracts, manuals and/or issued to the PIN/users. Its use is totally optional. There are PIN notes, support call/incident notes and customer notes. Each of the notes is stored in a different database, and have significantly different uses. After a period of time (days or weeks depending on the number of records you create), you need to perform a PACK. This process, located in the MISC ROUTINES, will remove records marked for deletion. This process WILL corrupt the indexes, so be sure to reindex after a PACK! DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 5 ■ MAIN MENU All major DAYO SC routines are accessed from the main menu. Unlike earlier DAYO modules, this menu is displayed at the bottom of the screen, accessed by function keys or the arrow keys. All major routines are accessed from the main menu of DAYO SC. These routines include: Read User Manual On Screen, Edit Current Open Support Call Record, Select Incoming (New) Support Call (generated by your VRU), Close Current Support Call, Edit Current Support Call Notes, Run External Program, Reports Menu, Select From Open Support Calls, Browse PIN Database, Browse Past (Closed) Support Call Records, Browse Customer Database, Supervisor Options & Configuration, Reindex All Databases and Display Available Memory. DAYO SC Version 4.00 TJS LAB, Inc. ┌────[June 1992]─────┐ Copyright (c) 1992 All Rights Reserved │S M T W T F S │ ██▄███░ ▄███▄ ██░ ██░ ▄███▄ ▄████░ ▄████░ ├────────────────────┤ ██░ ██░ ██░██░ ██░ ██░ ██░██░ ██░ ██░ │ 1 2 3 4 5│ ██░ ██░ ██░██░ ▀████▀ ██░██░ ▀███▄ ██░ │ 6 7 8 9 10 11 12│ ██░ ██░ ██▀▀▀██░ ██ ██░██░ ██░ ██░ │13 14 15 16 17 18 19│ ██▀███░ ██░ ██░ ██░ ▀███▀ ████▀ ▀████░ │20 21 22 23 24 25 26│ ┌───────────────────────────────────────────────────────┤27 28 29 30 31 │ │ User System Manager Time On 12:39:42│ │ └───────────────────────────────────────────────────────┴─────┤12:40:04├─────┘ Name Montgomery Sally Started 12:01:01 Reference 100012 Comment Problem DAYO Inventory Network - LANtastic Resolution Fixed Immediately PIN 21091006002 CBAJB006002 Start Date 10/15/91 End Date 12/01/93 Days Remaining 778 Calls 54 Address 4409 Beaumont Drive DOB 08/18/57 SSN 399-99-9999 Building 400 UF1 Printers UF2 City/ST/Zip ORLANDO FL 32810-0001 Call Limit 202 Phone 1 (407) 292-4708 Phone 2 (407) 291-3960 Customer ( 100) GEORGE FLOWERS, INC. 05/22/91 Different Phone Used 4072951704 Esc (Exit) F1 (Help) F2 (Edit) F3 (Incoming) F4 (Close) Alt N (Notes) Alt M (Menu) Alt R (Reports) Alt O (Open) Alt B (PIN) Alt H (History) Alt E (Customer) Alt Z (Supervisor) Alt F9 (Reindex) Alt f10 (Memory) Select Incoming (New) Support Call DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 6 ■ EXIT Press Esc or select the first option of the main menu to exit DAYO SC and return to DOS or a calling menu. ╔═══════════════╗ ║╔═════════════╗║ ║║╔═══════════╗║║ ║║║ Exit (Y/N)║║║ ║║╚═══════════╝║║ ║╚═════════════╝║ ╚═══════════════╝ ■ EDIT CURRENT SUPPORT CALL RECORD If you have already selected a support call record, you can edit it by pressing F2. The record will be displayed onto the main menu screen, as shown in the example on previous page. A pop-up window appears for the two problem category prompts and for the resolution prompt, ie: ╔══[ SELECT PROBLEM CATEGORY #1 ]══╗ ╔══[ SELECT PROBLEM CATEGORY #2 ]══╗ ║ CATEGORY ║ ║ CATEGORY ║ ║ ─────────────────────────────── ║ ║ ─────────────────────────────── ║ ║ DAYO Inventory ║ ║ Configuration ║ ║ DAYO Membership ║ ║ DOS 3.3 ║ ║ DAYO Order Entry ║ ║ DOS 4.01 ║ ║ DAYO POS ║ ║ DOS 5.0 ║ ║ DAYO Passwords ║ ║ DOS 6.0 ║ ║ DAYO Payroll ║ ║ DTP ║ ║ DAYO Quotes ║ ║ Indexing ║ ║ DAYO Rental POS ║ ║ Installation ║ ║ DAYO Sales Management System ║ ║ Menu ║ ║ DAYO Shipping Log ║ ║ Network - LANtastic ║ ╚══════════════════════════════════╝ ╚══════════════════════════════════╝ ╔══════[ SELECT RESOLUTION ]═══════╗ ║ RESOLUTION ║ ║ ─────────────────────────────── ║ ║ ║ ║ Could NOT fix! Gave up... ║ ║ Fixed After very much research ║ ║ Fixed Immediately ║ ║ Not our problem ║ ║ RECOMMEND TO GO BACK TO SCHOOL ║ ║ Read DOS Manual ║ ║ Read Network Manual ║ ║ Reindex Fixed It ║ ╚══════════════════════════════════╝ DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 7 ■ SELECT INCOMING PHONE CALL If you are using a Voice Response Unit (VRU), you can have it integrated with this program so that all new (incoming) support call records can 'automatically' be created when the PIN or customer calls into it. When using a VRU, press F3 to select an incoming call. Note, only one record will usually be present to select from. ╔═══════════════════════[ SELECT INCOMING PHONE CALL ]═══════════════════════╗ ║PIN CATEGORY1 CATEGORY2 ║ ║────────────╥────────────────────────────────╥──────────────────────────────║ ║21091006008 ║ Hardware ║ Printer, Oki 193 ║ ║21091006000 ║ Hardware ║ Printer, Laserjet ║ ║21091006001 ║ Software ║ Ventura ║ ║21091006003 ║ Hardware ║ Hand Scanner ║ ║21091006004 ║ Hardware ║ Mouse ║ ║21091006006 ║ Software ║ Windows ║ ╚════════════════════════════════════════════════════════════════════════════╝ ■ CLOSE CURRENT SUPPORT CALL Press F4 to close the current support call record. When you close a support call, a record of the call is made in the history database (HISTORY.DBF), which includes notes. A resolution code is required before a support call record can be closed. ╔════[ CLOSE CURRENT SUPPORT CALL! ]═════════════════════╗ ║ You are about to CLOSE this support call! ║ ║ ║ ║ Resolution -> Fixed! ║ ║ ║ ║ Are you sure? (Y/N) ║ ║ ║ ╚════════════════════════════════════════════════════════╝ DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 8 ■ EDIT SUPPORT CALL/INCIDENT NOTES Press Alt N while at the main menu, and after selecting an open support call/incident, to edit the notes specific to that call/incident, ie: ╔══════════════════════════════════════════════════════╗┌───[October 1992]───┐ ║ Name Elizabeth M Montgomery <OPEN> ║│S M T W T F S │ ║ Reference 100013 ║├────────────────────┤ ║ PIN 21091006000 CBAJB006000 ║│ 1 2 3 4 5│ ║ Problem Software ║│ 6 7 8 9 10 11 12│ ║ DTP ║│13 14 15 16 17 18 19│ ║ Resolution ║│20 21 22 23 24 25 26│ ║ Started 10/19/91 Time 12:01:01 ║┤27 28 29 30 31 │ ║ Technician System Manager ║│ │ ╚══════════════════════════════════════════════════════╝┴────────────────────┘ Type in anything you wish that pertains to the current support call incident. Approximately 18 pages... Esc (Exit) F1 (Help) F2 (Import) 1/0 ■ RUN MENU This routine was added to allow you to 'shell out' and run other programs or applications while keeping DAYO SC in memory. ╔═════════════════════[ 'RUN ANOTHER APPLICATION' MENU ]═════════════════════╗ ║FILENAME DESC LASTDATE LASTTIME RUNS ║ ║────────────╥────────────────────────────────╥──────────╥──────────╥────────║ ║BB.EXE ║ Blackbeard's Editor ║ 10/24/91 ║ 23:41:23 ║ 0 ║ ║WP.COM ║ Word Perfect for windows ║ 10/20/91 ║ 10:25:07 ║ 0 ║ ║COMMAND.COM ║ Exit To DOS ║ 10/20/91 ║ 15:13:35 ║ 541 ║ ║DAYOINV.EXE ║ DAYO INVENTORY ║ 10/19/91 ║ 20:49:15 ║ 7 ║ ║DAYOPOS.EXE ║ DAYO POS ║ 10/19/91 ║ 20:44:29 ║ 4 ║ ║DAYOSMS.EXE ║ DAYO Sales Mgmt System ║ 10/19/91 ║ 23:56:56 ║ 4 ║ ║PROCOMM.EXE ║ Procomm Plus Modem Program ║ 10/19/91 ║ 12:39:09 ║ 3 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Exit) Enter (Select) F2 (Edit) Ctrl N (Add) Press Enter to select and run one of the applications. The DAYO SC program memory will be placed into a temporary file and all but 11K memory will be freed. DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 9 ■ EDIT MENU RECORD Press F2 to edit a menu record, ie: ╔════[ EDIT MENU RECORD ]════════════════════════════════╗ ║ File Name NEW_PRG.EXE ║ ║ Location C:\ ║ ║ Description New program to list files ║ ║ Number of Runs 0 ║ ║ Last Date 10/20/91 ║ ║ Last Time 10:25:07 ║ ║ Date Added 10/20/91 ║ ║ Last User System Manager ║ ╚════════════════════════════════════════════════════════╝ ■ ADD MENU RECORD Press Ctrl N to add a new menu record. You will be presented with the edit screen above, but you must enter a valid program/file name (they have extensions of .EXE, .COM, and .BAT). Be sure to include a back slash '\' after the location (as shown above...). DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 10 ■ REPORTS This menu option contains reports, labels and routines that enable you to report your data. Most reports have multiple options that include indexes, directing output to printer or file, and date ranges. Use the arrow keys to select/highlight the desired report option, then press Enter/Return. DAYO SC Version 4.00 TJS LAB, Inc. ┌───[October 1992]───┐ Copyright (c) 1992 All Rights Reserved │S M T W T F S │ ██▄███░ ▄███▄ ██░ ██░ ▄███▄ ▄████░ ▄████░ ├────────────────────┤ ██░ ██░ ██░██░ ██░ ██░ ██░██░ ██░ ██░ │ 1 2 3 4 5│ ██░ ██░ ██░██░ ▀████▀ ██░██░ ▀███▄ ██░ │ 6 7 8 9 10 11 12│ ██░ ██░ ██▀▀▀██░ ██ ██░██░ ██░ ██░ │13 14 15 16 17 18 19│ ██▀███░ ██░ ██░ ██░ ▀███▀ ████▀ ▀████░ │20 21 22 23 24 25 26│ ┌───────────────────────────────────────────────────────┤27 28 29 30 31 │ │ User System Manager Time On 00:24:37 │ │ └───────────────────────────────────────────────────────┴─────┤00:25:15├─────┘ DAYO SUPPORT CALLS MANAGEMENT SYSTEM REPORTS Select Report -> Printer Setup PIN List PIN Labels PIN Phone List █▄██░ ███░ █▄██░ ▄█▄ █▄██░ ████░ ▄██▄ PIN Expanded Report █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░ PIN Usage/History Report █▄▄█░ ██░ █▄▄█░ █░█░ █▄▄█░ █░ ▀██▄ Open Call Log List █▀█░ █░ █░ █░█░ █▀█░ █░ █░ Daily Call Log Report █░██░ ███░ █░ ▀█▀ █░██░ █░ ▀██▀ Incident/Support Call Log Report Category #1/Problem List Category #2/Problem List Resolutions List Esc (Exit) F1 (Help) Enter (Select) ■ REPORTS LISTING Printer Setup Category #1/Problem List PIN List Category #2/Problem List PIN Labels Resolutions List PIN Phone List Customer List PIN Expanded Report Customer Labels PIN Usage/History Report Configuration Status Report Open Call Log List Calculator Daily Call Log Report View Reports On Screen Incident/Support Call Log Report DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 11 ■ PRINTER SETUP/DRIVER This routine was added to preclude you from having to get out of your seat to change (mess with) the printer to get it to print correctly. The most important printer selections (ie: font size, lines per inch, orientation, ...) are made easy to evoke. ╔════════════════════════════════════════════════════════════════════════════╗ ║ █▄██░█▄██░███░█░ █░█████░███░█▄██░ █▄██▄ █▄██░███░█░ █░███░█▄██░ ║ ║ █░ █░█░ █░ █░ ██░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░█░ █░ █░ ║ ║ █▀██░████░ █░ ███░█░ █░ ██░ ████░ █░ █░████░ █░ █▄ ▄█░██ ████░ ║ ║ █░ █░█░ █░ █░███░ █░ █░ █░█░ █░ █░█░█░ █░ █░█░ █░ █░█░ ║ ║ █░ █░▀█░ █░ █░ ██░ █░ █░ █░▀█░ █░ █░█░▀█░ █░ █▄█░ █░ █░▀█░ ║ ║ █░ █░ █░███░█░ █░ █░ ███░█░ █░ █▀██▀ █░ █░███░ █░ ███░█░ █░ ║ ║ ║ ║ Select Option -> Eject ║ ║ Line feed ║ ║ Normal Size ║ ║ Use this routine to set your Small/Condensed ║ ║ printer up with one or more Bold On ║ ║ of the setup strings and Bold Off ║ ║ commands listed to the right. 6 Lines per Inch ║ ║ 8 Lines per Inch ║ ║ Select the 'Change Printer Print Landscape (Laser Only) ║ ║ Default' option to change Print Portrait (Laser Only) ║ ║ printer types. Reset Printer ║ ║ Current printer is set to: Print Special String 1 ║ ║ Okidata Print Special String 2 ║ ║ Print Special String 3 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) ■ PRINTER DRIVER OPTIONS There are 18 printer driver options to select from. The last option is to set the default printer, and the next to last is a 'SHELL' function that runs a DOS command or program. The remainder are strings/codes that are sent to the printer. Eject Print Portrait (Laser Only) Line feed Reset Printer Normal Size Print Special String 1 Small/Condensed Print Special String 2 Bold On Print Special String 3 Bold Off Print Special String 4 6 Lines per Inch Print Special String 5 8 Lines per Inch Run DOS Command/Program Print Landscape (Laser Only) Change Default Printer DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 12 ■ CHANGE DEFAULT PRINTER The last option is to change/set the default printer. This printer driver routine comes with 4 default printer types, Epson, HP Laser, Star, and Okidata. You can add (Ctrl N) as many as you want. ╔════════════════════════════════════════════════════════════════════════════╗ ║ █▄██░█▄██░███░█░ █░█████░███░█▄██░ █▄██▄ █▄██░███░█░ █░███░█▄██░ ║ ║ █░ █░█░ █░ █░ ██░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░█░ █░ █░ ║ ║ █▀██░████░ █░ ███░█░ █░ ██░ ████░ █░ █░████░ █░ █▄ ▄█░██ ████░ ║ ║ █░ █░█░ █░ █░███░ █░ █░ █░█░ █░ █░█░█░ █░ █░█░ █░ █░█░ ║ ║ █░ █░▀█░ █░ █░ ██░ █░ █░ █░▀█░ █░ █░█░▀█░ █░ █▄█░ █░ █░▀█░ ║ ║ █░ █░ █░███░█░ █░ █░ ███░█░ █░ █▀██▀ █░ █░███░ █░ ███░█░ █░ ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ Current Default Printer is set to: Okidata ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ NAME LINEFEED ║ ║─────────────────────────────────────╥──────────────────────────────────────║ ║ Epson & Compatibles ║ CHR(10) ║ ║ HP Laser & Compatibles ║ CHR(10) ║ ║ Star Micro Gemini ║ CHR(10) ║ ║ Okidata ║ CHR(10) ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) Enter/Return (Make Default) F2 (Edit) Ctrl N (Add) 1/4 DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 13 ■ FULL SCREEN EDIT - PRINTER DRIVER When entering the printer codes, the string must be in the valid format or it will not be printed later when requested... ┌───────────[ EDIT PRINTER DRIVER SETUP CODES - FULL SCREEN EDIT ]───────────┐ │ NAME: Epson & Compatibles │ │ LINEFEED: CHR(10) │ │ NORMAL: CHR(27)+CHR(18) │ │ SMALL: CHR(27)+CHR(15) │ │ BOLDON: CHR(27)+CHR(69) │ │ BOLDOFF: CHR(27)+CHR(70) │ │ _6LPI: CHR(27)+CHR(50) │ │ _8LPI: CHR(27)+CHR(48) │ │ PORTRAIT: │ │ LANDSCAPE: │ │ RESET: CHR(27)+CHR(64) │ │ SPEC_STR1: │ │ SPEC_STR2: │ │ SPEC_STR3: │ │ SPEC_STR4: │ │ SPEC_STR5: │ │ RUN_CMD: │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit ■ PRINTER DRIVER DATABASE FIELD DEFINITIONS NAME - Name of printer. Type in anything you wish here LINEFEED - Code to advance printer one line NORMAL - Normal font/character size SMALL - Small font/character size BOLDON - Bold/Emphasized BOLDOFF - Bold/Emphasized off _6LPI - Code to set printer to print 6 lines per inch _8LPI - Code to set printer to print 8 lines per inch PORTRAIT - Code to set laser printer to print upright (normal) LANDSCAPE - Code to set laser printer to print sideways RESET - Reset printer code SPEC_STR1 - Any special printer string, ie: print double, skip perforation, SPEC_STR2 - print very tiny, ... SPEC_STR3 - " SPEC_STR4 - " SPEC_STR5 - " RUN_CMD - DOS command or program, ie: CAPTURE p0 nff,SPOOL ON, ... DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 14 ■ PIN LIST The PIN LIST consists of key fields of the Personal Identification Number (PIN) database (PIN.DBF). This report is 132 characters wide, so be sure to set your printer to print small if you do not have a wide carriage printer. The 1st prompt is for the index. Note, the first two options (PIN and Customer Number), already have indexes, but the remaining ones will have to be created... ╔════════════════════════════════[ PIN LIST ]════════════════════════════════╗ ║ This is a Simple PIN Listing indexed by one of seven indexes, ie: ║ ║ PIN, Customer Number, Name, Date, Ending Date, Last Problem, and ║ ║ Resolution. Note, only the first two indexes require an index. ║ ║ This Report is 132 characters wide. Uses Report Form: PINLIST.FRM. ║ ║ ║ ║ ║ ║ Select Index -> PIN ║ ║ Customer Number ║ ║ Name (Lastname, Firstname) ║ ║ Initiating Date ║ ║ Ending Date ║ ║ Last Problem ║ ║ Last Resolution ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 15 The next prompt is for the range or scope. This is where you defined what records will print, ie: All, specific customer number, or for a selected date range. ╔════════════════════════════════[ PIN LIST ]════════════════════════════════╗ ║ This is a Simple PIN Listing indexed by one of seven indexes, ie: ║ ║ PIN, Customer Number, Name, Date, Ending Date, Last Problem, and ║ ║ Resolution. Note, only the first two indexes require an index. ║ ║ This Report is 132 characters wide. Uses Report Form: PINLIST.FRM. ║ ║ ║ ║ ║ ║ Select Index -> PIN ║ ║ ║ ║ Select Option -> All Undeleted Records ║ ║ Specific PIN Type (Left 5 characters) ║ ║ Specific Customer Number ║ ║ Starting Date Range ║ ║ Ending Date Range ║ ║ Last Problem ║ ║ Last Resolution ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 16 If a specific field is selected, you will be prompted to enter the desired string to search for. You have the option of directing the output of the report to printer or file. ╔════════════════════════════════[ PIN LIST ]════════════════════════════════╗ ║ This is a Simple PIN Listing indexed by one of seven indexes, ie: ║ ║ PIN, Customer Number, Name, Date, Ending Date, Last Problem, and ║ ║ Resolution. Note, only the first two indexes require an index. ║ ║ This Report is 132 characters wide. Uses Report Form: PINLIST.FRM. ║ ║ ║ ║ ║ ║ Select Index -> PIN ║ ║ ║ ║ Select Option -> Specific PIN Type (Left 5 characters) ║ ║ ║ ║ Enter PIN type: 21091 ║ ║ ║ ║ ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║ Enter File Name: PINLIST.TXT ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 17 If you decided to direct the output to a printer, you will be presented with the option to 'setup' that printer, ie: ╔═══════════════════════════════════╗ ║ Select Printer Option(s) ║ ║ Printer: Epson & Compatibles ║ ║ Eject ║ ║ Line feed ║ ║ Normal Size ║ ║ Small/Condensed ║ ║ Bold On ║ ║ Bold Off ║ ║ 6 Lines per Inch ║ ║ 8 Lines per Inch ║ ║ Print Landscape (Laser Only) ║ ║ Print Portrait (Laser Only) ║ ║ Reset Printer ║ ║ Print Special String 1 ║ ║ Print Special String 2 ║ ║ Print Special String 3 ║ ║ Print Special String 4 ║ ║ Print Special String 5 ║ ║ Press Esc to Exit ║ ╚═══════════════════════════════════╝ Esc (Exit) F1 (Help) Use the PRINTER SETUP/DRIVER routine to defined/set the default printer. DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 18 ■ PIN LABELS This option lets you print address labels for your PIN records. The output is directed to the printer only. ╔═══════════════════════════════════════════════════════╗ ║Use this option to print the PIN address labels. ║ ║The Address Label is the standard size of: ║ ║ 3.5x15/16, 6LPI, and contains the following fields: ║ ║ FNAME + LNAME ADDRESS1 ADDRESS2 ║ ║ CITY STATE ZIP ║ ║ ║ ║ ╒══════════════════════════════╕ ║ ║ │GEORGE Sams │ ║ ║ │13 WEST COLONIAL │ ║ ║ │ │ ║ ║ │ORLANDO, FL │ ║ ║ │32802 │ ║ ║ ╘══════════════════════════════╛ ║ ║ PIN CUSTOMER FNAME ║ ║Select PIN -> 11091000018 100 ║ ║ 11091000019 100 ║ ║ 11091000020 100 ║ ║ 11091000021 100 GEORGE ║ ║ 11091000022 100 ║ ║Esc (Exit) Enter (Print) F3(ALL) F5/F6/F7/F8(Find) ║ ╚═══════════════════════════════════════════════════════╝ DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 19 ■ PIN PHONE LIST This is a report consisting of the PIN number and phone numbers. Options include multiple indexes, scope/range, and the option to print to printer or file. ╔═════════════════════════════[ PIN PHONE LIST ]═════════════════════════════╗ ║ This is a Simple PIN Telephone Listing indexed by one of seven indexes, ║ ║ ie: PIN, Customer Number, Name, Date, Ending Date, Last Problem, and ║ ║ Last Resolution. Note, only the first two indexes require an index. ║ ║ This Report is 80 characters wide. Uses Report Form: PINPHONE.FRM. ║ ║ ║ ║ ║ ║ Select Index -> PIN ║ ║ Customer Number ║ ║ Name (Lastname, Firstname) ║ ║ Initiating Date ║ ║ Ending Date ║ ║ Last Problem ║ ║ Last Resolution ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 20 ■ EXPANDED PIN REPORT This is a report consisting of the key PIN fields. Options include multiple indexes, scope/range, and the option to print to printer or file. ╔══════════════════════════[ EXPANDED PIN REPORT ]═══════════════════════════╗ ║ This is the Expanded PIN Report indexed by one of seven indexes, ie: ║ ║ PIN, Customer Number, Name, Date, Ending Date, Last Problem, and ║ ║ Resolution. Note, only the first two indexes require an index. ║ ║ This Report is 155 characters wide. Uses Report Form: PINRPT.FRM. ║ ║ ║ ║ ║ ║ Select Index -> PIN ║ ║ ║ ║ Select Option -> All Undeleted Records ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║ Enter File Name: PINRPT.TXT ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 21 ■ PIN USAGE & HISTORY REPORT This is a report consisting of the key incident/support call records of only closed incident records. Use this report to track usage. Options include scope/range and the option to print to printer or file. ╔═══════════════════════[ PIN USAGE & HISTORY REPORT ]═══════════════════════╗ ║ This is a report of all incidents/support calls for each PIN. ║ ║ The Report is only indexed by the PIN value. ║ ║ This Report is 132 characters wide. Uses Report Form: USAGE.FRM. ║ ║ ║ ║ ║ ║ Select Option -> All Undeleted Records ║ ║ Specific PIN or PIN Type ║ ║ Specific Customer Number ║ ║ Starting Date Range ║ ║ Ending Date Range ║ ║ Problem ║ ║ Resolution ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 22 ■ OPEN INCOMING PHONE LOG LISTING This is a simple listing of only the open incoming phone log records. Gets it's data from the database LOG.DBF. ╔════════════════════[ OPEN INCOMING PHONE LOG LISTING ]═════════════════════╗ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ ║ Enter File Name: LOGLIST.TXT ║ ╚════════════════════════════════════════════════════════════════════════════╝ ■ OPEN SUPPORT CALLS REPORT This is a report consisting of key fields of the open incidents/support call records. The report is wider than usual, so be sure to set your printer to print very small (even if you have a wide carriage printer). Options include multiple indexes, scope/range, and the option to print to printer or file. ╔═══════════════════════[ OPEN SUPPORT CALLS REPORT ]════════════════════════╗ ║ This is a report of all open & active incidents/support calls. ║ ║ The Report is indexed by one of seven indexes. ║ ║ This Report is 155 characters wide. Uses Report Form: OPEN.FRM. ║ ║ ║ ║ Select Index -> Reference Number ║ ║ PIN ║ ║ Customer Number ║ ║ Initiating Date + Time ║ ║ Problem ║ ║ Technician ║ ║ Comments ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 23 ■ CALL LOG (HISTORY) REPORT This report is almost identical to the Usage report, except that this one also includes the notes. Note, it only prints records with notes... The report is wider than usual, so be sure to set your printer to print very small (even if you have a wide carriage printer). Options include multiple indexes, scope/range, and the option to print to printer or file. ╔═══════════════════════[ CALL LOG (HISTORY) REPORT ]════════════════════════╗ ║ This is an complete report of all incidents/support calls for each PIN. ║ ║ The Report is only indexed by the PIN value. It is very similar to the ║ ║ USAGE report, but includes the incident notes. ║ ║ This Report is 155 characters wide. Uses Report Form: CALL_LOG.FRM. ║ ║ ║ ║ Select Option -> All Undeleted Records ║ ║ Specific PIN or PIN Type ║ ║ Specific Customer Number ║ ║ Starting Date Range ║ ║ Ending Date Range ║ ║ Problem ║ ║ Resolution ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) ■ CATEGORY #1 PROBLEM LISTING Use this option to print a listing of the category 1 problem codes to the printer or a file. ╔══════════════════════[ CATEGORY #1 PROBLEM LISTING ]═══════════════════════╗ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ ║ Enter File Name: CAT1LIST.TXT ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 24 ■ CATEGORY #2 PROBLEM LISTING Use this option to print a listing of the category 2 problem codes to the printer or a file. ╔══════════════════════[ CATEGORY #2 PROBLEM LISTING ]═══════════════════════╗ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ ║ Enter File Name: CAT2LIST.TXT ║ ╚════════════════════════════════════════════════════════════════════════════╝ ■ RESOLUTION LISTING Use this option to print a listing of the resolution codes to the printer or a file. ╔═══════════════════════════[ RESOLUTION LISTING ]═══════════════════════════╗ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ ║ Enter File Name: RESOLIST.TXT ║ ╚════════════════════════════════════════════════════════════════════════════╝ ■ CATEGORY #1 PROBLEM LISTING Use this option to print a listing of all your customer records to the printer or a file. ╔════════════════════════════[ CUSTOMER LISTING ]════════════════════════════╗ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ ║ Enter File Name: CUSTLIST.TXT ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 25 ■ CUSTOMER BILL TO ADDRESS LABELS Use this option to print labels containing the customer's address, to a printer only. ╔═══════════════════════════════════════════════════════╗ ║Use this option to print the Customer Bill To address ║ ║Labels. The Address Label is the standard size of ║ ║ 3.5x15/16, 6LPI, and contains the following fields: ║ ║ NAME ADDR1 ADDR2 ║ ║ CITY STATE ZIP ║ ║ ║ ║ ╒══════════════════════════════╕ ║ ║ │GEORGE MOONILAL │ ║ ║ │13 WEST COLONIAL │ ║ ║ │ │ ║ ║ │ORLANDO, FL │ ║ ║ │32802 │ ║ ║ ╘══════════════════════════════╛ ║ ║ CUSTOMER ║ ║Select Customer -> 120 ║ ║ 122 ║ ║ 123 ║ ║ 124 ║ ║ 135 ║ ║Esc (Exit) Enter (Print) F3(ALL) F5/F6/F7/F8(Find) ║ ╚═══════════════════════════════════════════════════════╝ DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 26 ■ CONFIGURATION STATUS REPORT This is a simple listing of your configuration settings. Note, you should keep this 'on file' should the configuration file get erased/lost... ╔═══════════════════════════════════════════════════════╗ ║The Configuration Status Settings Report lists all of ║ ║configuration settings (found in file DAYOSC.CFG). ║ ║This is Not a Report Form. ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: CONFIG.TXT ║ ╚═══════════════════════════════════════════════════════╝ ■ EXAMPLE OF A CONFIGURATION STATUS REPORT +++++++++++++++++++++++++++++++++++++++++++ + DAYO SUPPORT CALLS CONFIGURATION REPORT + +++++++++++++++++++++++++++++++++++++++++++ 10/28/91 23:07:20 Company Name: YOUR COMPANY, INC Address Line 1: Attn: Accounts Receivable Address Line 2: P.O. BOX 5555 City, State Zip: Anycity, ST 555555-5555 Telephone: 800-555-5555 Last Customer Number: 0 Allow Adding of Customer: Yes Customer Database Location: \DAYOAR\ Phone Log Database Location: Current Directory: Use Passwords: Yes Note Screen Size: 50 Screen Font #: 1 Default Excluded Menu Options: QC Report Printer Port: LPT1 Automatically Reindex Daily: Yes Color: Yes High Intensity: Yes Serial Number Conversion Codes Replace 0 with A Replace 1 with B Replace 2 with C Replace 3 with D Replace 4 with E Replace 5 with F Replace 6 with G Replace 7 with H Replace 8 with O Replace 9 with J DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 27 ■ CALCULATOR This routine emulates a calculator. Use the numeric key pad or number keys. ╔═════[ CALCULATOR ]═════╗ ║┌──────────────────────┐║ ║│ 101.000000 +│║ ║│ 50 │║ ║└──────────────────────┘║ ║ ┌─┐ ┌─┐ ┌─┐ ┌─┐ ┌─┐║ ║ │7│ │8│ │9│ │*│ │S│║ ║ └─┘ └─┘ └─┘ └─┘ └─┘║ ║ ┌─┐ ┌─┐ ┌─┐ ┌─┐ ┌─┐║ ║ │4│ │5│ │6│ │/│ │R│║ ║ └─┘ └─┘ └─┘ └─┘ └─┘║ ║ ┌─┐ ┌─┐ ┌─┐ ┌─┐ ┌─┐║ ║ │1│ │2│ │3│ │+│ │C│║ ║ └─┘ └─┘ └─┘ └─┘ └─┘║ ║ ┌─┐ TJS ┌─┐ ┌─┐ ┌─┐║ ║ │0│ LAB │.│ │-│ │E│║ ║ └─┘ INC └─┘ └─┘ └─┘║ ╚════════════════════════╝ ■ VIEW REPORTS ON SCREEN This routine was provided to aid the 'fight to stop the cutting down of trees in the world' by offering you the option to view your reports on your screen. The only limitation is on the size of the report. No reports can be viewed if they are over 32,000 bytes. (Just kidding about those trees...) Due to compiler problems (handling of memory), this routine tends to 'hang' your computer. It is not recommended you use this option if your machine is performing multitasking programs. At the first prompt, type and enter the name of the report you wish to view. ╔═════════════════════════▌ View Reports Onscreen ▐══════════════════════════╗ ║██ ██░ ████░ ████░ ██░ ██░ ██▄██░ █████░ ██▄██░ ▄███▄ ██▄██░ ██████║ ║ ██ ██░ ██░ ██░ ██░ █░ ██░ ██░██░ ██░ ██░██░ ██░██░ ██░██░ ██░ ║ ║ ██ ██░ ██░ ███░ ██░███░██░ █████░ ████░ █████░ ██░██░ █████░ ██░ ║ ║ ████░ ██░ ██░ ███░███░ ██▀█░ ██░ ██░ ██░██░ ██▀█░ ██░ ║ ║ ██░ ████░ ████░ ██░██░ ██░██░ █████░ ██░ ▀███▀ ██░██░ ██░ ║ ║ ║ ║ Use this option to view (and optionally print) any report written to disk. ║ ║ Press Enter/Return on an empty prompt to display all files with the ║ ║ extension of '.TXT'. ║ ║ No limit on file size, but a large file/report takes longer to 'load'... ║ ║ ║ ║ Enter Report File Name to View On Screen: ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 28 If the file does not exist, or you press enter on an empty prompt, a window will appear showing all reports in the current directory. It is assumed that all reports will have the extension of '.TXT', which is the DAYO standard. All reports are displayed in the window, even if they are too large... ╔═══════════════════════════════════════╗ ║ File Name Size Date Used ║ ╟──────────────┬────────────┬───────────╢ ║DAYOERR.TXT │ 1090 │ 06/15/90 ║ ║BALANCE.TXT │ 3555 │ 06/15/90 ║ ║GL900615.TXT │ 79 │ 06/15/90 ║ ║CONFIG.TXT │ 1209 │ 06/15/90 ║ ║BUDGETSC.TXT │ 4129 │ 06/15/90 ║ ║CLASSRPT.TXT │ 1058 │ 06/02/90 ║ ║COA.TXT │ 1158 │ 06/02/90 ║ ┌────────────────────────┐ ║GL900602.TXT │ 1759 │ 06/02/90 ║ │ Highlight the Report │ ║PERIODS.TXT │ 968 │ 06/15/90 ║ │ using the Up or Down │ ║TRANS3.TXT │ 659 │ 06/02/90 ║ │ arrow keys, then press │ ║TRIAL.TXT │ 6712 │ 06/15/90 ║ │ Enter/Return. │ ║INC_EXP.TXT │ 3291 │ 06/15/90 ║ └────────────────────────┘ ║TRANS1.TXT │ 659 │ 06/15/90 ║ ║ASSETS.TXT │ 1300 │ 06/15/90 ║ ║EQUITY.TXT │ 714 │ 06/15/90 ║ ╚══════════════╧════════════╧═══════════╝ DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 29 ■ REPORT VIEWING SCREEN The report viewing screen uses the complete screen. The top line displays the report name. The bottom lines show you the function keys, all 2 of them. Also displayed at the bottom of the screen is the current row/column of the cursor position. DAYORPT View Reports │ File Name: COA.TXT Page No. 1 07/27/90 INVENTORY ITEM LISTING Vendor or Item Mfg Item Description ------------ ------------ ------------------------------ 2"GUTTER 2" GUTTER SYSTEM _____________ 2ALM518 2" ALMOND COIL _____________ 2ALM519 2" ALMOND COIL _____________ 2ALM527 2" ALMOND COIL _____________ 2ALM533 2" ALMOND COIL _____________ 2ANT123 2" ANT IVORY COIL _____________ Esc (Exit) F1 (Help) DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 30 ■ BROWSE OPEN SUPPORT CALLS/RECORDS This is the routine you will use to store open support calls/incident records. From this routine you can edit the record or the notes for the currently highlighted record, or add a new record. * If you do not have a VRU, you will be using this routine to add all your new open support call records. ╔════[ OPEN SUPPORT CALLS ]════════════════════════════╗┌───[October 1992]───┐ ║ Name George Montgomery <OPEN> ║│S M T W T F S │ ║ Reference 100014 ║├────────────────────┤ ║ PIN 21091006003 ║│ 1 2 3 4 5│ ║ Problem First time use/installation of Ventura ║│ 6 7 8 9 10 11 12│ ║ DTP ║│13 14 15 16 17 18 19│ ║ Resolution ║│20 21 22 23 24 25 26│ ║ Started 10/19/91 Time 12:01:01 ║┤27 28 29 30 31 │ ║ Technician System Manager ║│ │ ╚══════════════════════════════════════════════════════╝┴─────┤23:17:26├─────┘ REFERENCE PIN CUSTOMER CATEGORY1 ───────────────╥─────────────╥──────────╥───────────────────────────────────── 100004 ║ 21091006005 ║ 100 ║ Hardware 100005 ║ 21091006006 ║ 100 ║ Hardware 100006 ║ 21091006004 ║ 100 ║ Hardware 100007 ║ 21091006001 ║ 100 ║ Software 100010 ║ 21091006006 ║ 100 ║ Hardware 100012 ║ 21091006002 ║ 100 ║ DAYO Inventory 100013 ║ 21091006000 ║ 100 ║ Hardware 100014 ║ 21091006003 ║ 100 ║ Software/Ventura 100015 ║ 21091006004 ║ 100 ║ Hardware Esc (Exit) F1 (Help) Enter (Select) F2 (Edit) Alt N (Note) Ctrl N (Add) Ctrl U (Delete) Find: F5 (Reference) F6 (PIN) F7 (Open + PIN) DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 31 ■ FULL SCREEN EDIT - OPEN SUPPORT CALL RECORD Press F2 to edit all the fields of the currently highlighted open support call records. ┌────────────[ FULL SCREEN EDIT - SUPPORT CALL/INCIDENT RECORD ]─────────────┐ │ REFERENCE: 100004 │ │ PIN: 21091006005 │ │ CUSTOMER: 100 │ │ CATEGORY1: Hardware │ │ CATEGORY2: Printer │ │ RESOLUTION: │ │ COMMENTS: │ │ PHONE: 4072924708 │ │ DATE: 10/19/91 │ │ TIME: 12:01:01 │ │ ENDDATE: / / │ │ ENDTIME: │ │ TECHNICIAN: SYSTEM MANAGER │ │ CLOSEDBY: │ │ OPEN: T │ │ │ │ │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 32 ■ EDIT SUPPORT CALL/INCIDENT NOTES Press Alt N to edit the notes (up to 18 pages), for the currently highlighted record. The screen size can be 25, 43 or 50 lines. The screen size is set in the configuration menu. ╔══════════════════════════════════════════════════════╗┌───[October 1992]───┐ ║ Name Brenda Montgomery ║│S M T W T F S │ ║ Reference 100004 ║├────────────────────┤ ║ PIN 21091006005 CBAJB006005 ║│ 1 2 3 4 5│ ║ Problem Software ║│ 6 7 8 9 10 11 12│ ║ DTP ║│13 14 15 16 17 18 19│ ║ Resolution ║│20 21 22 23 24 25 26│ ║ Started 10/19/91 Time 12:01:01 ║┤27 28 29 30 31 │ ║ Technician SYSTEM MANAGER ║│ │ ╚══════════════════════════════════════════════════════╝┴────────────────────┘ Write in anything you wish into this space that pertains to the current support call/incident. Esc (Exit) F1 (Help) F2 (Import) 1/0 DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 33 ■ ADD SUPPORT CALL/INCIDENT RECORD Press Ctrl N to add/create a new support call/incident record. The first prompt will be for a valid/existing customer, then you will be prompted to edit the new/empty record. ┌──────────[ FULL SCREEN EDIT - ADD SUPPORT CALL/INCIDENT RECORD ]───────────┐ │ PIN CUSTOMER FNAME LNAME │ │ Select ─────────────────╥──────────╥─────────────────╥────────────────────│ │ PIN -> 11091000039 ║ 100 ║ Lorraine ║ Turner │ │ 11091000040 ║ 100 ║ Michael ║ Smith │ │ 11091000041 ║ 100 ║ Darrell ║ Kelly │ │ 11091000042 ║ 100 ║ Paul Lenard ║ Johnson │ │ 11091000043 ║ 100 ║ Mark ║ Johnson │ │ 11091000044 ║ 100 ║ GEORGE ║ Moonilal │ │ 21091006000 ║ 100 ║ Elizabeth M ║ Montgomery │ │ 21091006001 ║ 100 ║ Joe ║ Montgomery │ │ 21091006002 ║ 100 ║ Sally ║ Montgomery │ │ 21091006003 ║ 100 ║ George ║ Montgomery │ │ 21091006004 ║ 100 ║ Ronald ║ Montgomery │ │ 21091006005 ║ 100 ║ Brenda ║ Montgomery │ │ 21091006006 ║ 100 ║ Paul ║ Montgomery │ │ 21091006007 ║ 100 ║ Paul ║ Montgomery │ │ 21091006008 ║ 100 ║ Paul ║ Montgomery │ └────────────────────────────────────────────────────────────────────────────┘ Esc (Exit) F1 (Help) Enter (Select) Find: F5/F6/F7/F8 Alt F (FastFind) 11/119 ■ FIND PIN RECORD WHILE CREATING A NEW SUPPORT CALL RECORD There are four (4) indexes for the PIN database (PIN.DBF). Press F5 to find a PIN record based on the PIN number, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter PIN: │ └───────────────────────────────────────────────────TJS LAB───┘ Press F6 to find a PIN record based on the customer number, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter CUSTOMER: 0 │ └───────────────────────────────────────────────────TJS LAB───┘ DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 34 Press F7 to find a PIN record based on the first name, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter FNAME: │ └───────────────────────────────────────────────────TJS LAB───┘ Press F8 to find a PIN record based on the last name, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter LNAME: │ └───────────────────────────────────────────────────TJS LAB───┘ ■ FAST FIND PIN WHILE CREATING A NEW SUPPORT CALL RECORD This special search routine lets you locate PIN records with only parts (strings) of the PIN last name, first name, phone 1 and/or zip code, ie: ╔════════════════════════════════════════════════════════════════════════════╗ ║ PIN FAST FIND ║ ║ PIN Last Name First Name Phone 1 Zip ║ ║ 21091006003 Montgomery George 4072924708 32810-0001║ ║ 12323006004 Jones George (407) 555-4204 32831 ║ ║ 43555506006 Moonilal George (407) 555-4234 32736 ║ ║ 11091006021 Smith George (407) 555-2048 32825 ║ ║ 11091000044 Tallahassee George (407) 555-9348 32832 ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ Enter String(s): GEORGE ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) Enter (Select) F1 (Help) DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 35 ■ FIND INCIDENT/SUPPORT CALL RECORD The open support call database (OPEN.DBF), is indexed by three (3) indexes, but only the first 2 are useful. The 3rd index simply puts the open record before the closed ones (OPEN=.T.). Press F5 to locate an open support call record based on the reference number, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter REFERENCE: 0 │ └───────────────────────────────────────────────────TJS LAB───┘ Press F6 to locate an open support call record based on the PIN, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter PIN: │ └───────────────────────────────────────────────────TJS LAB───┘ Press F7 to locate an open support call record based on the status (whether it is open or not). This search routine is useful only if you want to go to the top of the file and see the oldest, but still OPEN support call/incident record. ┌─────────────────────────────────────────────────────────────┐ │ Enter IIF(OPEN,CHR(48),CHR(49))+STR(REFERENCE): │ └───────────────────────────────────────────────────TJS LAB───┘ DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 36 ■ BROWSE PIN DATABASE This is the maintenance routine for the PIN records. From this routine, you can edit the record, add new records and edit the PIN notes. ╔════[ PIN DATABASE BROWSE ]═══════════════════════════╗┌───[October 1992]───┐ ║ Name GEORGE Calls 0 ║│S M T W T F S │ ║ Started 11091000044 BBAJB000044 ║├────────────────────┤ ║ PIN 10/20/91 / / ║│ 1 2 3 4 5│ ║ Last Problem ║│ 6 7 8 9 10 11 12│ ║ ║│13 14 15 16 17 18 19│ ║ Last Resolution ║│20 21 22 23 24 25 26│ ║ City/State/Zip ORLANDO, FL 32802 ║┤27 28 29 30 31 │ ║ Phones (407) 292-4708 (407) 295-2171 ║│ │ ╚══════════════════════════════════════════════════════╝┴─────┤23:31:55├─────┘ PIN CUSTOMER FNAME LNAME ──────────────────────╥──────────╥─────────────────╥────────────────────────── 11091000044 ║ 100 ║ GEORGE ║ 21091006000 ║ 100 ║ Elizabeth M ║ Montgomery 21091006001 ║ 100 ║ Joe ║ Montgomery 21091006002 ║ 100 ║ Sally ║ Montgomery 21091006003 ║ 100 ║ George ║ Montgomery 21091006004 ║ 100 ║ Ronald ║ Montgomery 21091006005 ║ 100 ║ Brenda ║ Montgomery 21091006006 ║ 100 ║ Paul ║ Montgomery 23423423423 ║ 43423 ║ 2342 ║ 3423 Esc (Exit) F1 (Help) F2 (Edit) Alt N (PIN Notes) Ctrl N (Add) Find: F5 (PIN) F6 (Customer) F7 (FName) F8 (LName) Alt F (FastFind) 119/119 DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 37 ■ FULL SCREEN EDIT - PIN RECORD Press F2 to edit an open support call record. ┌─────────────[ FULL SCREEN EDIT - SUPPORT CALL/INCIDENT RECORD ]────────────┐ │ PIN: 11091000044 LASTTIME: 22:25:45 │ │ CUSTOMER: 100 │ │ FNAME: GEORGE │ │ LNAME: │ │ ADDRESS1: 13 WEST COLONIAL │ │ ADDRESS2: │ │ CITY: ORLANDO │ │ STATE: FL │ │ ZIP: 32802 │ │ PHONE1: (407) 292-4708 │ │ PHONE2: (407) 295-2171 │ │ DOB: / / │ │ SSN: │ │ DATE: 10/20/91 │ │ TIME: 22:25:45 │ │ ENDDATE: / / │ │ CALLS: 0 │ │ LASTCAT1: │ │ LASTCAT2: │ │ LASTRESOLU: │ │ LASTDATE: 10/20/91 │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit ■ FIND PIN RECORD There are four (4) indexes for the PIN database (PIN.DBF). Press F5 to find a PIN record based on the PIN number, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter PIN: │ └───────────────────────────────────────────────────TJS LAB───┘ Press F6 to find a PIN record based on the CUSTOMER number, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter CUSTOMER: 0 │ └───────────────────────────────────────────────────TJS LAB───┘ DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 38 Press F7 to find a PIN record based on the first name, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter FNAME: │ └───────────────────────────────────────────────────TJS LAB───┘ Press F8 to find a PIN record based on the last name, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter LNAME: │ └───────────────────────────────────────────────────TJS LAB───┘ ■ FAST FIND PIN This special search routine lets you locate PIN records with only parts (strings) of the PIN last name, first name, phone 1 and/or zip code, ie: ╔════════════════════════════════════════════════════════════════════════════╗ ║ PIN FAST FIND ║ ║ PIN Last Name First Name Phone 1 Zip ║ ║ 21091006003 Montgomery George 4072924708 32810-0001║ ║ 12323006004 Jones George (407) 555-4204 32831 ║ ║ 43555506006 Moonilal George (407) 555-4234 32736 ║ ║ 11091006021 Smith George (407) 555-2048 32825 ║ ║ 11091000044 Tallahassee George (407) 555-9348 32832 ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ Enter String(s): GEORGE ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) Enter (Select) F1 (Help) DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 39 ■ EDIT PIN NOTES Press Alt N to edit the notes (up to 18 pages), for the currently highlighted record. The screen size can be 25, 43 or 50 lines. The screen size is set in the configuration menu. ╔══════════════════════════════════════════════════════╗┌───[October 1992]───┐ ║ Name George Montgomery ║│S M T W T F S │ ║ PIN 21091006003 CBAJB006003 ║├────────────────────┤ ║ Last Date 10/25/91 ║│ 1 2 3 4 5│ ║ ██▄███░ ████░ ██░ ██░ ║│ 6 7 8 9 10 11 12│ ║ ██░ ██░ ██░ ███▄ ██░ ║│13 14 15 16 17 18 19│ ║ ██████░ ██░ ███████░ NOTES ║│20 21 22 23 24 25 26│ ║ ██░ ██░ ██░▀███░ ║┤27 28 29 30 31 │ ║ ██░ ████░ ██░ ██░ ║│ │ ╚══════════════════════════════════════════════════════╝┴────────────────────┘ Type in anything you want that pertains specifically to the selected/current PIN/Customer... Esc (Exit) F1 (Help) F2 (Import) 1/0 DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 40 ■ BROWSE HISTORY OF SUPPORT CALLS DATABASE This is the maintenance routine for the history of support calls records. From this routine, you can edit the record, add new records and edit the support call/incident notes. The records in this database are created when you close an open support call/record. Data is 'moved' from the OPEN database to the HISTORY database. ╔════[ HISTORY OF SUPPORT CALLS ]══════════════════════╗┌───[October 1992]───┐ ║ Name George Montgomery ║│S M T W T F S │ ║ Reference 100071 ║├────────────────────┤ ║ PIN 21091006003 ║│ 1 2 3 4 5│ ║ Problem Hardware ║│ 6 7 8 9 10 11 12│ ║ Printer ║│13 14 15 16 17 18 19│ ║ Resolution ║│20 21 22 23 24 25 26│ ║ Started 10/25/91 Ended 10/25/91 Days 0 ║┤27 28 29 30 31 │ ║ Technician System Manager ║│ │ ╚══════════════════════════════════════════════════════╝┴─────┤23:33:23├─────┘ REFERENCE PIN CUSTOMER CATEGORY1 ───────────────╥─────────────╥──────────╥──────────────────────────────────── 100071 ║ 21091006003 ║ 100 ║ Hardware 100003 ║ 21091006003 ║ 100 ║ Hardware 100014 ║ 21091006003 ║ 100 ║ Hardware 100018 ║ 21091006003 ║ 100 ║ Hardware 100031 ║ 21091006003 ║ 100 ║ Hardware 100039 ║ 21091006003 ║ 100 ║ Hardware 100048 ║ 21091006003 ║ 100 ║ Hardware 100060 ║ 21091006003 ║ 100 ║ Hardware 100003 ║ 21091006003 ║ 100 ║ Hardware Esc (Exit) F1 (Help) F2 (Edit) Alt N (Notes) Find: F5 (Reference) F6 (PIN) 17/74 DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 41 ■ FULL SCREEN EDIT - HISTORY SUPPORT CALL/INCIDENT RECORD Press F2 to edit the currently highlighted support call history record. ┌─────────────[ FULL SCREEN EDIT - SUPPORT CALL/INCIDENT RECORD ]────────────┐ │ REFERENCE: 100071 │ │ PIN: 21091006003 │ │ CUSTOMER: 100 │ │ CATEGORY1: Hardware │ │ CATEGORY2: Printer │ │ RESOLUTION: Dip Switches │ │ COMMENTS: │ │ PHONE: 4072924708 │ │ DATE: 10/25/91 │ │ TIME: 12:01:01 │ │ ENDDATE: 10/25/91 │ │ ENDTIME: 00:15:18 │ │ TECHNICIAN: System Manager │ │ CLOSEDBY: System Manager │ │ OPEN: F │ │ │ │ │ │ │ │ │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 42 ■ EDIT HISTORY SUPPORT CALL/INCIDENT NOTES Press Alt N to edit the notes pertaining to the currently highlighted record. The screen size can be 25, 43 or 50 lines. The screen size is set in the configuration menu. ╔══════════════════════════════════════════════════════╗┌───[October 1992]───┐ ║ Name George Montgomery ║│S M T W T F S │ ║ Reference 100071 ║├────────────────────┤ ║ PIN 21091006003 CBAJB006003 ║│ 1 2 3 4 5│ ║ Problem Software ║│ 6 7 8 9 10 11 12│ ║ DTP ║│13 14 15 16 17 18 19│ ║ Resolution ║│20 21 22 23 24 25 26│ ║ Started 10/25/91 Ended 10/25/91 Days 0 ║┤27 28 29 30 31 │ ║ Technician System Manager ║│ │ ╚══════════════════════════════════════════════════════╝┴────────────────────┘ Notes pertaining to the incident go in the full screen editor/notes section Esc (Exit) F1 (Help) F2 (Import) 1/0 ■ FIND HISTORY SUPPORT CALL/INCIDENT RECORD The HISTORY database (HISTORY.DBF) is indexed by two (2) indexes. Press F5 to find a history record based on the reference number. Note, the reference number must be 'padded' with leading spaces in order for the seek function to work. ┌─────────────────────────────────────────────────────────────┐ │ Enter DESCEND(STR(REFERENCE)+DTOS(ENDDATE)): │ └───────────────────────────────────────────────────TJS LAB───┘ Press F6 to find a history record based on the PIN (or a portion of it), ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter DESCEND(PIN+DTOS(ENDDATE)): │ └───────────────────────────────────────────────────TJS LAB───┘ DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 43 ■ BROWSE CUSTOMERS This is the routine that lets you view and optionally add, customer records. Note, no editing of the record is permitted, but you can add a customer record. It is recommended that the customer record be edited from the DAYO AR module. The record can be edited in the MISC Routines, but this often corrupts the index... ╔════════════════════════════════════════════════════════════════════════════╗ ║ BILL TO: SHIP TO: ║ ║ GEORGE MOONILAL ║ ║ 13 WEST COLONIAL ║ ║ ║ ║ ORLANDO, FL 32802 ║ ║ CUSTOMER # TYPE SALESPER TERMS SHIPPER ║ ║ 100 REG LT CASH PICKUP ║ ║ PHONE ATTN LASTDATE ║ ║ (407) 292-4708 RICH LAROSSA 104091.64 10/01/91 ║ ╚══════════════════════[ BROWSE THE CUSTOMER DATABASE ]══════════════════════╝ CUSTOMER NAME ATTN ───────────╥────────────────────────────────╥───────────────────────────────── 100 ║ GEORGE MOONILAL ║ RICH LAROSSA 101 ║ HARRY MORGAN ║ HARRY 102 ║ AL'S SPECIAL CHEESEBURGERS ║ AL 117 ║ ENERGYVISION ║ GINO 164 ║ HARPER FLOWERS ║ SANDRA 188 ║ DAVE NICKERSON ENT. ║ 292 ║ JOHNSON'S MOBILE HOME REPAIR ║ 294 ║ ABLE GLASS ║ OSCAR Esc (Exit) F1 (Help) Ctrl N (Add) Ctrl U (Delete/Recall) Find: F5(Customer) F6(Name) F7(ShipTo) F8(Phone) F9(Zip) 128/146 DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 44 ■ ADD A NEW RECORD - FULL SCREEN EDIT Press Ctrl N to add a new customer record. Note, the option to be able to do this can be 'turned off' in the configuration menu. ┌──────────────────[ ADD A NEW RECORD - FULL SCREEN EDIT ]───────────────────┐ │ CUSTOMER: 10331 LASTDATE: / / │ │ NAME: TYPE: REG │ │ ATTN: CLASS: AR │ │ ADDR1: PBM: 0.000 │ │ ADDR2: PBL: 0.000 │ │ CITY: SALESPTD: 0.00 │ │ STATE: SALESYTD: 0.00 │ │ ZIP: DUE: 0.00 │ │ SHIPNAME: PAID_PURC: 0.00 │ │ SHIPADDR1: LIMIT: 0.00 │ │ SHIPADDR2: ACTIVE: T │ │ SHIPCITY: TAXCODE: │ │ SHIPSTATE: FAX: │ │ SHIPZIP: SHIPPHONE: │ │ PHONE: FOB: │ │ SALESPER: PRICEX: 0 │ │ RATE: 0.000 CREDCARD: │ │ TAXRATE: 0.0000 TAXRATE2: 0.00000 │ │ TERMS: CUSCODE: │ │ SHIPPER: │ │ DATE: 10/29/91 │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit ■ FIND CUSTOMER RECORD There are 5 indexes for the customer database. Press F5 to find a customer record based on the customer number, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter CUSTOMER: 0 │ └───────────────────────────────────────────────────TJS LAB───┘ Press F6 to find a customer record based on the name, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter NAME: │ └───────────────────────────────────────────────────TJS 43 DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 45 Press F7 to find a customer record based on the customer ship to name, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter SHIPNAME: │ └───────────────────────────────────────────────────TJS LAB───┘ Press F8 to find a customer record based on the right 4 digits of the telephone number, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter right 4 digits Phone: │ └───────────────────────────────────────────────────TJS LAB───┘ Press F10 to find a customer record based on the zip code, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter ZIP: │ └───────────────────────────────────────────────────TJS LAB───┘ DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 46 ■ SUPERVISOR OPTIONS (CONFIGURATION) This is the menu of all the configuration options and special routines. The key fields are the company name, address and database locations. ╔════════════════════════╗ ║ SUPERVISOR OPTIONS ║ ╟────────────────────────╢ ║ Company Name ║ ║ Company Address ║ ║ Company Telephone ║ ║ Last Reference # ║ ║ Allow Customer Add ║ ║ Customer Location ║ ║ Phone Log Location ║ ║ Current Directory ║ ║ Browse Category #1 ║ ║ Browse Category #2 ║ ║ Browse Resolutions ║ ║ Serial Number Codes ║ ║ Notes Screen Size ║ ║ Assign PIN Blocks ║ ║ Browse Phone Log ║ ║ Excluded Options ║ ║ Use Passwords ║ ║ Passwords ║ ╟────────────────────────╢ ║ Select Option ║ ╚════════════════════════╝ ■ CONFIGURATION LISTING Company Name Browse Phone Log Company Address Excluded Options Company Telephone Use Passwords Last Reference # Passwords Allow Customer Add Global Pack & Reindex Customer Location Misc Routines Phone Log Location Screen Fonts Current Directory System Statistics Browse Category #1 Report Printer Port Browse Category #2 Auto Daily Indexing Browse Resolutions Color Serial Number Codes High Intensity Notes Screen Size Credits Assign PIN Blocks DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 47 ■ COMPANY NAME This is the name of your company or organization. ╔══════════════════════════════[ COMPANY NAME ]══════════════════════════════╗ ║ Enter Your Company Name: YOUR COMPANY, INC ║ ╚════════════════════════════════════════════════════════════════════════════╝ ■ COMPANY ADDRESS This is the address of your company or organization. ╔════════════════════════════[ COMPANY ADDRESS ]═════════════════════════════╗ ║ Address Line 1: Attn: Accounts Receivable ║ ║ Address Line 2: P.O. BOX 5555 ║ ║ City, State ZIP: Anycity, ST 555555-5555 ║ ╚════════════════════════════════════════════════════════════════════════════╝ ■ COMPANY TELEPHONE This is the telephone number of your company or organization. ╔═══════════════════════════[ COMPANY TELEPHONE ]════════════════════════════╗ ║ Enter Your Company Telephone: 800-555-5555 ║ ╚════════════════════════════════════════════════════════════════════════════╝ ■ LAST REFERENCE NUMBER This option lets you determine what the next support call/incident number (REFERENCE) will be. Note, keep the number much less than 999,999, since this is the maximum, and will cause errors if the number exceeds this! ╔═════════════════════════[ LAST REFERENCE NUMBER ]══════════════════════════╗ ║ Note, this option should be maintained by the System Manager! ║ ║ ║ ║ Enter Last Reference Number: 100075 ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 48 ■ ALLOW CUSTOMER ADD This option determines if customer records can be added to the customer database while viewing/browsing the customer database. The default is to allow it, but in many environments, it is not recommended, especially where DAYO accounting modules are being used... ╔═══════════════════════════[ ALLOW CUSTOMER ADD ]═══════════════════════════╗ ║ If you want the ability to add customer records while in the Customer ║ ║ Browse routine, then select Y (Yes) to this option. Note, it is not ║ ║ recommended to add customer records from DAYO SC if you have DAYO AR ║ ║ or DAYO POS installed! Default is to allow customer add. ║ ║ ║ ║ Do you want to add customer records? (Y/N) ║ ╚════════════════════════════════════════════════════════════════════════════╝ ■ CUSTOMER DATABASE LOCATION/DIRECTORY This is the location of the customer database (CUSTOMER.DBF). The default is to use the one found in the DAYO AR directory (if installed). If no other DAYO module is installed, you will be using the one in the current directory, so leave the field blank. ╔══════════════════[ CUSTOMER DATABASE LOCATION/DIRECTORY ]══════════════════╗ ║ The location of the DAYO Customer file (CUSTOMER.DBF) does not have to be ║ ║ in the same drive/directory as DAYO SC. If you have installed the DAYO ║ ║ Customer Database (CUSTOMER.DBF), into a different directory, you need ║ ║ to tell DAYO SC where to find it. Default is nil (current directory). ║ ║ Be sure to include the rightmost slash, ie: \DAYOAR\ ║ ║ The drive designation is optional (if same as DAYO SC). ║ ║ ║ ║ Enter Location: \DAYOAR\ ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 49 ■ 'RAW' PHONE LOG DATABASE LOCATION/DIRECTORY This is the location of the Voice Response Unit (VRU) Files. It can not be the same directory as DAYO SC or can it 'share' it with any other files. All files in this directory will be ERASED when used in the INCOMING option. If you do not have a VRU, then ignore this option. ╔══════════════[ 'RAW' PHONE LOG DATABASE LOCATION/DIRECTORY ]═══════════════╗ ║ The location of the Telephone Log Files that are generated by the ║ ║ Voice Response Unit (VRU), should be a directory of its own. It can not ║ ║ be the same directory as DAYO SC! ║ ║ Default is current directory + '\LOG', ie: \DAYOSC\LOG\ ║ ║ Be sure to include the rightmost back slash... ║ ║ ║ ║ ║ ║ Enter Location: ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ ■ CURRENT DIRECTORY DATABASE LOCATION Use this option to defined the location of the DAYOSC databases if not in the current directory. ╔══════════════════[ CURRENT DIRECTORY DATABASE LOCATION ]═══════════════════╗ ║ This module's databases can be located in a different location other ║ ║ than the current directory. If you have and wish to use ALL the ║ ║ databases currently found in this directory from a different drive and ║ ║ directory, then you need to tell this module where to find them. ║ ║ Be sure to include the rightmost slash, ie: C:\DAYOSC\ ║ ║ The drive designation is optional if same as this module. ║ ║ ║ ║ Enter Location: ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 50 ■ BROWSE PROBLEM CATEGORY #1 This is the maintenance routine for the editing and adding of category #1 problem codes, ie: ╔══[ BROWSE PROBLEM CATEGORY #1 ]══╗ ║ CATEGORY ║ ║ ─────────────────────────────── ║ ║ BRAIN ║ ║ DAYO AP ║ ║ DAYO AR ║ ║ DAYO End of Period ║ ║ DAYO GL ║ ║ DAYO Index ║ ║ DAYO Inventory ║ ║ DAYO Membership ║ ║ DAYO Order Entry ║ ║ DAYO POS ║ ║ DAYO Passwords ║ ║ DAYO Payroll ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚══════════════════════════════════╝ Esc (Exit) F1 (Help) F2 (Edit) Ctrl N (Add) Ctrl U (Delete) ■ FULL SCREEN EDIT - CATEGORY 2 RECORD Press F2 to edit a category #1 record, which consists of only the problem code. ┌─────────────────────[ FULL SCREEN EDIT - EDIT RECORD ]─────────────────────┐ │ CATEGORY: Configuration │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 51 ■ BROWSE PROBLEM CATEGORY #2 This is the maintenance routine for the editing and adding of category #2 problem codes, ie: ╔══[ BROWSE PROBLEM CATEGORY #2 ]══╗ ║ CATEGORY ║ ║ ─────────────────────────────── ║ ║ Configuration ║ ║ DOS 3.3 ║ ║ DOS 4.01 ║ ║ DOS 5.0 ║ ║ DOS 6.0 ║ ║ DTP ║ ║ Indexing ║ ║ Installation ║ ║ Menu ║ ║ Network - LANtastic ║ ║ Network - Novell ║ ║ Network - Other ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚══════════════════════════════════╝ Esc (Exit) F1 (Help) F2 (Edit) Ctrl N (Add) Ctrl U (Delete) ■ FULL SCREEN EDIT - CATEGORY 2 RECORD Press F2 to edit a category #2 record, which consists of only the problem code. ┌─────────────────────[ FULL SCREEN EDIT - EDIT RECORD ]─────────────────────┐ │ CATEGORY: Pagemaker │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 52 ■ BROWSE RESOLUTION DATABASE This is the maintenance routine for the editing and adding of resolution codes, ie: ╔══[ BROWSE RESOLUTION DATABASE ]══╗ ║ RESOLUTION ║ ║ ─────────────────────────────── ║ ║ ║ ║ Could NOT fix! Gave up... ║ ║ Fixed After very much research ║ ║ Fixed Immediately ║ ║ Not our problem ║ ║ RECOMMEND TO GO BACK TO SCHOOL ║ ║ Read DOS Manual ║ ║ Read Network Manual ║ ║ Reindex Fixed It ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚══════════════════════════════════╝ Esc (Exit) F1 (Help) F2 (Edit) Ctrl N (Add) Ctrl U (Delete) 2/9 ■ FULL SCREEN EDIT - RESOLUTION RECORD Press F2 to edit a resolution record, which consists of only the code. ┌─────────────────────[ FULL SCREEN EDIT - EDIT RECORD ]─────────────────────┐ │ RESOLUTION: Could NOT fix! │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 53 ■ EDIT SERIAL NUMBER CODES Serial number are actually the PIN numbers, just coded/encrypted. This option lets you determine how you want the first 5 digits of the PIN encrypted. PINs are composed on numeric digits only, but this process will generate and display a serial number (to be issued to users or placed on or in manuals). Using the settings below, the following PIN will be coded as shown. PIN -> 31091006000 ||||| SERIAL NUMBER -> DBAJB006000 ╔════════════════════════[ EDIT SERIAL NUMBER CODES ]════════════════════════╗ ║ Serial Numbers are Codes PIN numbers. For each numeric digit of the ║ ║ PIN number, you have the option of assigning a replacement character. ║ ║ Use Serial Numbers to assign to individual support packages... ║ ║ Note, leave the prompt blank if you do not want a change or conversion. ║ ║ ║ ║ Convert '0' to: A ║ ║ Convert '1' to: B ║ ║ Convert '2' to: C ║ ║ Convert '3' to: D ║ ║ Convert '4' to: E ║ ║ Convert '5' to: F ║ ║ Convert '6' to: G ║ ║ Convert '7' to: H ║ ║ Convert '8' to: O ║ ║ Convert '9' to: J ║ ╚════════════════════════════════════════════════════════════════════════════╝ ■ EDIT NOTES - SCREEN MODE: 25, 43 (EGA), or 50 (VGA) LINES If you have an EGA or VGA screen, you can edit the notes (PIN or Support Call/Incident), using 25, 43, or 50 lines. EGA can use 25 or 43, VGA can use all three options. ╔═══════[ EDIT NOTES - SCREEN MODE: 25, 43 (EGA), or 50 (VGA) lines ]════════╗ ║ If you have an EGA or VGA card, you have the option to display more ║ ║ than the usual 25 lines per screen while editing any Notes. ║ ║ The default is 43 lines if EGA or VGA is installed, else 25... ║ ║ ║ ║ Select Option -> Normal: 25 lines ║ ║ EGA: 43 lines ║ ║ VGA: 50 lines ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 54 ■ ASSIGN PIN BLOCKS/NUMBERS Use this routine to add/create new PIN records if you sell multiple packages (PINs) to a customer. Use the Ctrl N (Add) function in the PIN Database Browse routine to add the PIN records if only one PIN record is created for each customer. Each PIN is made up of a type code, month, year and a number value. You are prompted to enter each of these values, but the system will increment the number as it creates the records. The example screen below shows how 10 PIN records will be created for customer number '100': ╔═══════════════════════[ ASSIGN PIN BLOCKS/NUMBERS ]════════════════════════╗ ║ Format (11 digits), ie: 30191006000 ║ ║ Type Month Year Number ║ ║ 9 99 99 999999 ║ ║ ║ ║ Enter Customer Number: 100 Enter Type: 1 ║ ║ Name SHERRY JOHNSON Month: 11 ║ ║ Address #5 GEORGETOWN Year: 91 ║ ║ 962 GEORGETOWN Starting Number: 10 ║ ║ NORTH AUGUSTA, SC 29841 Ending Number: 10 ║ ║ 803 278-4304 Maximum Calls: 0 ║ ║ Number of Days: 0 ║ ║ ║ ║ Valid TYPEs: '0' through '9' ║ ║ Set the Maximum Calls to Zero (0) if no limit on number of calls. ║ ║ Set the Number of Days to Zero (0) if no limit on number of days. ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 55 The progress of the PIN adding is displayed/scrolled upon the screen, ie: ╔═══════════════════════[ ASSIGN PIN BLOCKS/NUMBERS ]════════════════════════╗ ║ Format (11 digits), ie: 30191006000 ║ ║ Type Month Year Number ║ ║ 9 99 99 999999 ║ ║ ║ ║ Enter Customer Number: 100 Enter Type: 1 ║ ║ Name GEORGE MOONILAL Month: 10 ║ ║ Address 13 WEST COLONIAL Year: 91 ║ ║ 13 WEST COLONIAL Starting Number: 11 ║ ║ ORLANDO, FL 32802 Ending Number: 20 ║ ║ (407) 292-4708 ║ ║ ║ ║ ║ ║ Standby! Adding new/blank PIN records (no names) ║ ║ 1 10 91 001009 11091000017 7 of 10 ║ ║ 1 10 91 001008 11091000016 6 of 10 ║ ║ 1 10 91 001007 11091000015 5 of 10 ║ ║ 1 10 91 001006 11091000014 4 of 10 ║ ║ 1 10 91 001005 11091000013 3 of 10 ║ ║ 1 10 91 001004 11091000012 2 of 10 ║ ║ 1 10 91 001003 11091000011 1 of 10 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) ■ BROWSE 'RAW' PHONE LOG DATABASE This is the maintenance routine for the VRU generated telephone log. ╔════════════════════[ BROWSE 'RAW' PHONE LOG DATABASE ]═════════════════════╗ ║ PIN CATEGORY1 ║ ║────────────────────────────╥───────────────────────────────────────────────║ ║ 21091006001 ║ Software ║ ║ 21091006003 ║ Software ║ ║ 21091006005 ║ Hardware ║ ║ 21091006007 ║ Hardware ║ ║ 21091006008 ║ Hardware ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) F2 (Edit) Ctrl N (Add) Ctrl U (Delete) <DELETED> 1/51 DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 56 ■ FULL SCREEN EDIT - VRU/LOG.DBF RECORD Press F2 to edit the VRU log/database record. Note, the number of fields will vary depending on the manufacturer of the VRU... ┌─────────────────────[ FULL SCREEN EDIT - EDIT RECORD ]─────────────────────┐ │ PIN: 21091006001 │ │ CATEGORY1: Software │ │ CATEGORY2: DTP │ │ PHONE: 4072924708 │ │ DATE: 10/15/91 │ │ TIME: 12:01:01 │ │ CLOSED: T │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 57 ■ DEFAULT EXCLUDED MAIN MENU OPTIONS (USED WITH PASSWORDS) If you activate the passwords routine, you can exclude your users from the main menu options by assigning them excluded option codes listed below. This option prompts you to enter the excluded codes that you want all new users/passwords to have (they can be overridden). Excluded Main Menu Excluded Main Menu Code Option Code Option ──── ───────────── ──── ───────────────────── Q Esc (Exit) R Alt R (Reports) H F1 (Help) O Alt O (Open) 2 F2 (Edit) B Alt B (PIN) 3 F3 (Incoming) P Alt H (History Browse) 4 F4 (Close) C Ctrl C (Customer) N Alt N (Notes) Z Alt F1 (Supervisor) M Alt M (Menu) X Alt F9 (Reindex) ╔════════[ DEFAULT EXCLUDED MAIN MENU OPTIONS (USED WITH PASSWORDS) ]════════╗ ║ The default excluded menu options in this prompt will become the ║ ║ default for each new user/technician added in the Password Routine. ║ ║ ║ ║ Enter the Default Excluded Main Menu Options: QC ║ ╚════════════════════════════════════════════════════════════════════════════╝ ■ USE PASSWORDS This option turns off/on the use of passwords. Note, the default for the use of passwords is NOT to activate them. ╔═════════════════════════════[ USE PASSWORDS ]══════════════════════════════╗ ║ Use this option to activate/deactivate the requirement for passwords. ║ ║ The default is to deactivate the passwords... ║ ║ ║ ║ Use Passwords? (Y/N) ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 58 ■ PASSWORDS MAINTENANCE If you use passwords, this is the routine that you will use to add and edit them. Note, the password is stored in an encrypted format, but is displayed (decrypted) onto the center screen. *** Password information is contained in the file: 'CALLOG.CFG'. ╔═════════════════════════[ PASSWORDS MAINTENANCE ]══════════════════════════╗ ║ Excluded Main Menu Excluded Main Menu ║ ║ Code Option Code Option ║ ║ Q Esc (Exit) R Alt R (Reports) ║ ║ H F1 (Help) O Alt O (Open) ║ ║ 2 F2 (Edit) B Alt B (PIN) ║ ║ 3 F3 (Incoming) P Alt H (History Browse) ║ ║ 4 F4 (Close) C Ctrl C (Customer) ║ ║ N Alt N (Notes) Z Alt F1 (Supervisor) ║ ║ M Alt M (Menu) X Alt F9 (Reindex) ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ Name SYSTEM MANAGER Password TJ Active Yes ║ ║ Login SUPERVISOR Status Logged Out Date 10/15/91 ║ ║ Exclude Options Started 10/28/91 Time 23:17:12 ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ PASSWORD LOGIN NAME ║ ║──────────╥────────────────────────────────╥────────────────────────────────║ ║ SH ║ SUPERVISOR ║ SYSTEM MANAGER ║ ║ SH ║ TOM ║ Thomas Lyle Johnson ║ ║ d?eK ║ BOSS ║ John Michael Gonzales ║ ║ ahyK ║ REG_001 ║ REGISTER #1 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) F2 (Edit) Ctrl N (Add) Ctrl U (Delete) ■ EDIT/ADD PASSWORD Press F2 to edit a password record, or Ctrl N to add a new one. The edit screen for either is in the center of the screen. DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 59 ■ NOVELL NETWORK & PASSWORDS If you are running Novell's Netware (tm), you can configure the network to make it possible for DAYO SC to automatically read the username, validate it, and then enter the program without even stopping to ask for a password. If installed onto a Novell (tm) network, the SUPERVISOR must make or insure that the 'MACHINE NAME' statement is found in the LOGIN SCRIPT. The LOGIN SCRIPT can be edited from within the SYSCON program. The use of the MACHINE NAME statement is not necessary if passwords are not used. ┌────────────────────────────────────────────────────────────────────────────┐ │NetWare System Configuration V2.20d Saturday May 11, 1992 6:32 pm│ │ User SUPERVISOR On File Server ORLANDO │ └────────────────────────────────────────────────────────────────────────────┘ ╔════════════════════════════════════════════════════════════════════════════╗ ║ System Login Script ║ ╠════════════════════════════════════════════════════════════════════════════╣ ║MAP G:=VOL1:\ ║ ║MAP INS S1:=SYS:\PUBLIC ║ ║MAP INS S1:=ORLANDO/SYS:\WORD5 ║ ║MAP INS S1:=ORLANDO/SYS:\UTILITY ║ ║MAP INS S1:=ORLANDO/SYS:\ATC\EXE ║ ║MAP INS S1:=ORLANDO/SYS:\ATC\NS ║ ║MAP INS S1:=ORLANDO/SYS:\MHS\EXE ║ ║DOS SET MV="ORLANDO/SYS:" ║ ║ ║ ║MACHINE NAME=LOGIN_NAME ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Call us for any help on this matter if you have a Novell network running. DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 60 ■ GLOBAL PACK & REINDEX This option simply indexes all databases. Requires exclusive use of all databases accessed by DAYO SC. ╔════════════════[ GLOBAL PACK & REINDEX ]══════════════════╗ ║ This routine REQUIRES EXCLUSIVE USE of the databases! ║ ║ That means that everyone must be out of the databases ║ ║ if on a network... ║ ║ This is the routine that PACKS all DAYO SC databases, ║ ║ removing any records marked for deletion! Note, this ║ ║ routine should be performed at least monthly... ║ ║ ║ ║ ║ ║ Are You Sure? (Y/N) ║ ╚═══════════════════════════════════════════════════════════╝ DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 61 ■ MISCELLANEOUS ROUTINES The MISC routines is a collection of 17 very useful Database Management Routines. These routines provide you with the 'ability to do whatever was left out of the rest of the program...'. These routines were modeled after dBase (tm) III+/IV functions. Familiarity with dBase will help with the understanding and execution of these routines. This routine option is found inside the Supervisor's menu (Alt Z from main menu). USE WITH CAUTION! YOU CAN ENHANCE AND CUSTOMIZE YOUR PROGRAM WITH THESE ROUTINES YOU CAN ALSO MESS THINGS UP PERMANENTLY! ■ MISC ROUTINES MENU: DAYO SC Version 2.01 TJS LAB, Inc. ┌───[November 1992]──┐ ╔════════════════════╗═══╗ghts Reserved │S M T W T F S │ ║ MISC ROUTINES ║ ║███▄ ▄████░ ▄████░ ├────────────────────┤ ╟────────────────────╢╔═════════════════════════════════════════════════════╗│ ║ APPEND FROM ║║ This menu option provides you with a multitude of ║│ ║ BROWSE DATABASES ║║ database management tools and functions, but also ║│ ║ COPY (.DBF) TO ║║ can be a source of significant problems! ║│ ║ CREATE DATABASE ║║ ║│ ║ DELETE RECORDS ║║ Miscellaneous Routines was provided to give you a ║│ ║ ERASE FILE ║║ 'back door' to DAYO, but if used incorrectly, it ║┘ ║ EXIT TO DOS ║║ can damage or destroy your data! ║ ║ INDEX A DATABASE ║║ ║ ║ LIST FIELDS ║║ Adding records to databases, packing, appending, ║ ║ PACK DATABASE ║║ editing records and modify databases can ║ ║ MODIFY DATABASE ║║ corrupt the indexes related to the database(s)! ║ ║ RECALL RECORDS ║║ You must know to reindex (Alt F9) if you do any ║ ║ RETURN TO MENU ║║ of these operations... ║ ║ RUN (DOS COMMAND) ║║ ║ ║ SIMPLE EDITOR ║║ When modifying a database, the rule is to NEVER ║ ║ SORT DATABASE ║║ change an existing field; only to add new fields...║ ║ TYPE (PRINT) FILE ║║ ║ ║ ZAP DATABASE ║║ Remember that 'ZAP' means to remove (permanently) ║ ╟────────────────────╢║ all records in the selected database! ║ ║ Select Option ║╚═════════════════════════════════════════════════════╝ ╚════════════════════╝═══╝ DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 62 ■ APPEND FROM Used to copy records from one database into another database, or to create records from ASCII files (SDF or DELIMITED). The Initial Screen will prompt you to enter the file name of the database you are to append/copy the data into. At this point, you can either type in the name of the target database, or ... ┌──────────────────────────────[ APPEND FROM ]───────────────────────────────┐ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ └────────────────────────────────────────────────────────────────────────────┘ If it exists in the current directory, press enter on an empty prompt to display all databases to select from. ┌──────────────────────────────[ APPEND FROM ]──────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter┌────────[ PICK A DATABASE ]───────────┐y... │ │ │ FILE NAME SIZE DATE USED│ │ │ ├──────────────┬────────────┬──────────┤ │ │ │INVENT.DBF │ 375 │ 09/16/89 │ │ │ │AR.DBF │ 7219 │ 09/16/89 │ │ │ │HISTORY.DBF │ 103 │ 09/16/89 │ │ │ │PERSONS.DBF │ 24271 │ 09/16/89 │ │ │ │CUSTOMER.DBF │ 289 │ 09/16/89 │ │ │ └──────────────┴────────────┴──────────┘ │ │ ┌───────────────────────┐│ │ │ Highlight a database ││ │ │ using the ││ │ │ arrow keys, then press││ │ │ Enter/Return. ││ │ └───────────────────────┘│ │ │ └───────────────────────────────────────────────────────────────────────────┘ The next prompt will be to select the type of Append: ┌──────────────────────────────[ APPEND FROM ]─────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ Append Data Into INVENT.DBF │ │ │ │ Type of Append: Standard SDF DELIMITED │ │ │ └──────────────────────────────────────────────────────────────────────────┘ DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 63 If you are appending from another database (.DBF) then select 'Standard'. Select the SDF option if you are appending from a 'flat' ASCII file. Select the DELIMITED option if you are appending from a delimited ASCII file. Delimited files contain records in which the fields are separated by commas, and its character fields contained in double quotes... If you select a Standard Append, you will then be prompted to enter the name of the database you wish to get the data from. If you selected the SDF or DELIMITED options, then enter the file name containing the data to be appended into your target database. ┌──────────────────────────────[ APPEND FROM ]─────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ Append Data Into PERSONS.DBF │ │ │ │ Type of Append: Standard SDF DELIMITED │ │ │ │ Enter Database Name To Append Data FROM: PERSON1.TXT │ │ │ │ │ └──────────────────────────────────────────────────────────────────────────┘ The number of records appended into the target database will be displayed upon completion of the task... ┌──────────────────────────────[ APPEND FROM ]───────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ Append Data Into INVENT.DBF From INVENTY.DBF │ │ │ │ Type of Append: Standard SDF DELIMITED │ │ │ │ Enter Database Name To Append Data FROM: INVENTY.DBF │ │ │ │ │ │ │ │ There Were 1 Records Appended Into INVENT.DBF │ │ │ │ │ │ │ │ Press Any Key To Continue... │ │ │ └────────────────────────────────────────────────────────────────────────────┘ DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 64 ■ BROWSE DATABASES Used to edit/view records in a database. Enter the database name you wish to edit/browse, or if it exists in the current directory, press enter on an empty prompt to bring up a window box to select from. ┌───────────────────────────────────────────────────────────────┐ │ Enter Database Name: INVENT.DBF │ │ │ └───────────────────────────────────────────────────────────────┘ If there exists an index (.NDX or .NTX), with the same name as the database, it will be utilized... The DAYO Inventory indexes are the exception. They are automatically set/used. An example of a browse screen: TJS LAB, PO BOX 585366 ┌────────────────────────────────[ BROWSE SDF ]──────────────────────────────┐ │ MFG_PART DESC PRICE LIST │ │──────────────────╥────────────────────────────────╥────────────╥───────────│ │ 19730 ║ DAYO CONFIGURATION SETTINGS ║ 896.16 ║ 1792.32 │ │ 23429 ║ DAYO CUSTOMER ║ 1064.19 ║ 2128.38 │ │ 14797 ║ DAYO END OF PERIOD/DAY ║ 672.12 ║ 1344.24 │ │ 38227 ║ DAYO FINANCE,PERSONNEL,PAYROLL ║ 1736.31 ║ 3472.62 │ │ 11098 ║ DAYO INVENTORY ║ 504.09 ║ 1008.18 │ │ 17264 ║ DAYO MISC ROUTINES ║ 784.14 ║ 1568.28 │ │ 30828 ║ DAYO PICK, INVOICING ║ 1400.25 ║ 2800.50 │ │ 35760 ║ DAYO PURCHASE ORDERS ║ 1624.29 ║ 3248.58 │ │ 25896 ║ DAYO QUOTES ║ 1176.21 ║ 2352.42 │ │ 62889 ║ DAYO ROPA ║ 2856.51 ║ 5713.02 │ │ 64122 ║ DAYO ROPA/ROPC SOURCE ║ 2912.52 ║ 5825.04 │ │ 28362 ║ DAYO SALES ORDERS, P.O.S. ║ 1288.23 ║ 2576.46 │ │ 33294 ║ DAYO VENDORS ║ 1512.27 ║ 3024.54 │ │ 66588 ║ DBASE TRAINING (PER HOUR) ║ 3024.54 ║ 6049.08 │ │ 16031 ║ EOP SOURCE ║ 728.13 ║ 1456.26 │ │ 49325 ║ EXPENSES SOURCE ║ 2240.40 ║ 4480.80 │ │ 39460 ║ FINANCE SOURCE ║ 1792.32 ║ 3584.64 │ ├──────────────────╨────────────────────────────────╨────────────╨───────────┤ │ Esc(EXIT) Ctrl N(ADD) Ctrl U(DELETE) F5(Find) │ └────────────────────────────────────────────────────────────────────────────┘ 51/60 DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 65 To edit a memo field, just highlight the field, and start typing. * * * To save your work, once finished, YOU MUST PRESS Ctrl W UPON EXITING! ┌────────────────────────────────[ BROWSE SDF ]──────────────────────────────┐ │ PRICE LIST YOURPART NOTES │ │───────────────────────╥────────────╥─────────────────╥─────────────────────│ │ 896.16 ║ 1792.32 ║ ║ <Memo> │ │ 1064.19 ║ 2128.38 ║ ║ <Memo> │ │ 672.12 ║ 1344.24 ║ ║ <Memo> │ │ 1736.31 ║ 3472.62 ║ ║ <Memo> │ │ 504.09 ║ 1008.18 ║ ║ <Memo> │ │ 784.14 ║ 1568.28 ║ ║ <Memo> │ │ 1400.25 ║ 2800.50 ║ ║ <Memo> │ ┌────────────────────────────[ Edit Field: NOTES ] ──────────────────────────┐ │You can edit memo fields too... │ │ │ │ │ │ │ │ │ │ │ │ │ └───────────────────────[ Esc (ABORT) Ctrl W (SAVE) ]─────────────────────┘ │ Esc(EXIT) Ctrl N(ADD) Ctrl U(DELETE) F5(Find) │ └────────────────────────────────────────────────────────────────────────────┘ Special keys for 'moving around' the BROWSE screen are: Left Arrow Key - Move to next field to your left Right Arrow Key - Move to next field to your right Ctrl Home - Go to the leftmost field Ctrl End - Go to the rightmost field (on the end of the record) Up Arrow - Move highlight to the previous record Down Arrow - Move highlight to the next record PgUp - Page up a full screen of records PgDn - Page down a full screen of records Ctrl PgUp - Go to the beginning of the file Ctrl PgDn - Go to the end or last record of the file Ctrl N - Add a record (where applicable) Ctrl U - Delete a record (where applicable) F5 - To seek/find a record based upon the active index Esc - Exit the current operation Remember that there are many more fields to the right of the screen. Press the right arrow key to view them... DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 66 ■ COPY (.DBF) TO Copy records to another (new) database. Use this option to copy select records into a new database or ASCII (SDF and DELIMITED) file. COPY TO can also be used to create backups of data (IE: copy to floppy). ┌─────────────────────────────[ COPY (.DBF) TO ]─────────────────────────────┐ │ │ │ Enter Database Name To COPY FROM: │ │ Enter┌────────[ PICK A DATABASE ]───────────┐y... │ │ │ FILE NAME SIZE DATE USED│ │ │ ├──────────────┬────────────┬──────────┤ │ │ │HARPS.DBF │ 375 │ 09/16/89 │ │ │ │INVENT.DBF │ 7335 │ 09/16/89 │ │ │ │SDFSTUF.DBF │ 103 │ 09/16/89 │ │ │ │MORETRAH.DBF │ 24387 │ 09/16/89 │ │ │ │AP.DBF │ 289 │ 09/16/89 │ │ │ └──────────────┴────────────┴──────────┘ │ │ ┌───────────────────────┐│ │ │ Highlight a database ││ │ │ using the ││ │ │ arrow keys, then press││ │ │ Enter/Return. ││ │ └───────────────────────┘│ └────────────────────────────────────────────────────────────────────────────┘ The next prompt will be to select the type of COPY TO option you want: ┌──────────────────────────────[ COPY (.DBF) TO ]────────────────────────────┐ │ │ │ Enter Database Name To COPY FROM: INVENT.DBF │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ │ │ Copy Records From INVENT.DBF │ └────────────────────────────────────────────────────────────────────────────┘ The Standard option is simply creating another database (.DBF). The SDF and DELIMITED options will create ASCII files. The STRUCTURE option creates a new database with the same file structure as the initial database (no records copied). DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 67 The next prompt (optional), requires some knowledge of dBase (tm). This prompt is requesting the user to enter a condition or filter. If all records are to be copied, just press Enter on an empty prompt. ┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐ │║ ║│ │║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│ │║NOTES{M} ■ ║│ │╚══════════════════════════════════════════════════════════════════════════╝│ │ │ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ Enter SDF File Name To Copy Data TO: NEW.DBF │ │ │ │ Enter Condition: │ │ Sample condition: COST > 100 │ │ │ │ │ │ Copy Records From NEW │ └────────────────────────────────────────────────────────────────────────────┘ This 'Condition' option is useful for coping only specific records into a new location. Any valid dBase/Clipper statement (as shown next) is fine... ┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐ │║ ║│ │║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│ │║NOTES{M} ■ ║│ │╚══════════════════════════════════════════════════════════════════════════╝│ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ Enter SDF File Name To Copy Data TO: NEW DBF │ │ │ │ Enter Condition: PRICE>0 │ │ Sample condition: COST > 100 │ │ │ │ Copy Records From NEW │ └────────────────────────────────────────────────────────────────────────────┘ DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 68 The following window message will appear while the COPY TO routine does its task: ┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐ │║ ║│ │║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│ │║NOTES{M} ■ ║│ │╚══════════════════════════════════════════════════════════════════════════╝│ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ Enter SDF File Name To Copy Data TO: NEW10 │ │ │ │ Enter Condition: PRICE>0 │ │ Sample cond┌───────────────────────────────────────────────┐ │ │ │┌─────────────────────────────────────────────┐│ │ │ CONDITION: ││┌───────────────────────────────────────────┐││ │ │ │││┌─────────────────────────────────────────┐│││ │ │ ││││Hold those camels while I do this COPY TO││││ │ │ │││└─────────────────────────────────────────┘│││ │ │ ││└───────────────────────────────────────────┘││ │ │ │└─────────────────────────────────────────────┘│ │ │ └───────────────────────────────────────────────┘ │ │ Copy Records From SDF To NEW10 │ └────────────────────────────────────────────────────────────────────────────┘ ■ CREATE DATABASE Create a new database. This routine lets you create entirely new database structures. At the FIELD_NAME field, enter a unique field name. At the FIELD_TYPE field, enter a 'C' for character, 'N' for numeric, 'D' for Date, 'L' for logical or 'M' for memofield. At the FIELD_LEN field, enter the size/length of the character and/or numeric field. At the FIELD_DEC field, enter the number of decimals for the numeric field. ┌───────[ CREATE A NEW DATABASE: NEW.DBF ]────────┐ │ FIELD_NAME FIELD_TYPE FIELD_LEN FIELD_DEC │ │────────────╥────────────╥───────────╥───────────│ │ ║ ║ 0 ║ 0 │ │ ║ ║ ║ │ │ ║ ║ ║ │ ┌─────────────│ ║ ║ ║ │────────────┐ │ │ ║ ║ ║ │ │ │ ENTER TH│ ║ ║ ║ │ │ │ │ ║ ║ ║ │ │ └─────────────│ ║ ║ ║ │────────────┘ │────────────╨────────────╨───────────╨───────────│ │ Press Enter to edit any field... │ └──────[ PRESS Ctrl W TO SAVE AND EXIT ]────────┘ DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 69 * * * TO EDIT ANY FIELD, YOU MUST PRESS Enter FIRST * * * IT IS SLIGHTLY BOTHERSOME SORRY! WANT YOU TO THINK ABOUT WHAT YOU ARE DOING... *** If any error is made in this routine, you will experience an error, either immediately, or when you start to edit the new database. This error may even cause your computer to hang! *** Be sure to Press: Ctrl W when you are finished and satisfied. Pressing Esc will just negate your efforts.. ┌───────[ CREATE A NEW DATABASE: NEW.DBF ]────────┐ │ FIELD_NAME FIELD_TYPE FIELD_LEN FIELD_DEC │ │────────────╥────────────╥───────────╥───────────│ │ NAME ║ C ║ 30 ║ 0 │ │ AGE ║ N ║ 5 ║ 1 │ │ DEAD ║ L ║ 1 ║ 0 │ │ BIRTHDATE ║ D ║ 8 ║ 0 │ ┌─────────────│ REMARKS ║ M ║ 10 ║ 0 │────────────┐ │ │ ║ ║ 0 ║ 0 │ │ │ ENTER TH│ ║ ║ ║ │ │ │ │ ║ ║ ║ │ │ │ │ ║ ║ ║ │ │ └─────────────│ ║ ║ ║ │────────────┘ │ ║ ║ ║ │ │────────────╨────────────╨───────────╨───────────│ │ Press Enter to edit any field... │ └──────[ PRESS Ctrl W TO SAVE AND EXIT ]────────┘ DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 70 ■ DELETE RECORDS Delete selected records from databases. The first prompt is for the name of the database you wish to mark records for deletion. Like many of the other routines, you can press enter on an empty prompt to bring up all databases that exist in the current directory: ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │D.DBF │ 259 │ 09/16/89 │ │DDD.DBF │ 375 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SDF.DBF │ 7335 │ 09/16/89 │ │TRASH.DBF │ 24387 │ 09/16/89 │ │XXX.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌────────────────────────[ DELETE SELECTED RECORDS ]│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ │ └────────────────────────┘ │ │ └────────────────────────────────────────────────────────────────────────────┘ After selecting the database, all its fields will be presented atop the screen so as to aid the user in entering a condition/filter. The use of the condition prompt is NOT optional, so some knowledge of dBase/Clipper syntax is required. Note the use of the Clipper Function: EMPTY(). ╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌────────────────────────[ DELETE SELECTED RECORDS ]─────────────────────────┐ │ Enter Database Name: TRASH │ │ Delete Records For Condition: EMPTY(PART) │ │ Sample condition: COST > 100 │ │ CONDITION: EMPTY(PART) │ │ Number of Records Deleted: 208 │ │ Press any key to continue... │ └────────────────────────────────────────────────────────────────────────────┘ The number of records deleted will be displayed upon the screen as depicted just above... DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 71 ■ ERASE FILE Erase a file (forever!). Use this option with extreme care! Again, be careful! ANY FILE SELECTED WITH THIS OPTION WILL BE PERMANENTLY REMOVED FROM EXISTENCE NO SECOND CHANCES HERE... The first prompt is for the file name. You can press enter on an empty prompt to bring up a window selection of all files in the current directory. ┌────────────────────────┐ ┌────────[ ERASE THE FILE ]────────────┐ │ Highlight a file │ │ FILE NAME SIZE DATE USED│ │ using the │ ├──────────────┬────────────┬──────────┤ │ arrow keys, then press │ │B.BAT │ 222 │ 09/16/89 │ │ Enter/Return. │ │BKDOOR.$$$ │ 8192 │ 09/16/89 │ └────────────────────────┘ │BKDOOR.DOC │ 37029 │ 09/17/89 │ │BKDOOR.ZIP │ 19415 │ 09/16/89 │ │D.DBF │ 259 │ 09/16/89 │ │D.DBT │ 512 │ 09/16/89 │ │DAYOBK.BAK │ 36879 │ 09/16/89 │ │DAYOBK.LIB │ 36879 │ 09/16/89 │ │DAYOBK.LST │ 2056 │ 09/16/89 │ │DAYOBK.OBJ │ 35585 │ 09/16/89 │ │DAYOCAL.MAP │ 35 │ 09/16/89 │ │DDD.DBF │ 375 │ 09/16/89 │ │DDD.DBT │ 512 │ 09/16/89 │ │DDD.NTX │ 2048 │ 09/16/89 │ │DEMO.EXE │ 245404 │ 09/16/89 │ └──────────────┴────────────┴──────────┘ More * To ERASE a file, just highlight it, then press Enter... ■ EXIT TO DOS This option will close all open files and databases and exit to DOS without having to return to the main menu exit routine. DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 72 ■ INDEX A DATABASE You will be prompted to select the database you wish to index. After selecting the database, by typing in the name or pressing Enter on an empty prompt (then selecting from the window), you will be given a listing of all fields in that database atop the screen. ┌────────[ PICK A DATABASE ]───────────┐. │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │DAD.DBF │ 259 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SPW.DBF │ 7335 │ 09/16/89 │ │SOW.DBF │ 103 │ 09/16/89 │ │BOY.DBF │ 24387 │ 09/17/89 │ │SHI.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌───────────────────[ INDEX A DATABASE ]───│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ │ └────────────────────────┘ └───────────────────────────────────────────────────────────────┘ You will now be prompted to enter the name of the Index File. It will be (by default), named exactly the same as the selected database, with the exception of the extension. This will default to .NDX or .NTX depending on whether you linked NDX.OBJ with your application. *** Remember that the BROWSE routine only looks at indexes with the same name as the database. ╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ INDEX A DATABASE ]────────────────────────┐ │ Enter Name of Index File: TRASH.NTX │ └───────────────────────────────────────────────────────────────┘ DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 73 At the prompt for the index key, enter a field name, or a valid dBase/Clipper expression. ╒╔══════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ INDEX A DATABASE ]────────────────────────┐ │ Enter Name of Index File: TRASH.NTX │ │ Enter the Key Expression: PART+MFG_PART │ └───────────────────────────────────────────────────────────────┘ ■ LIST FIELDS List fields to screen or printer. This routine is a great tool for providing simple reports and lists. The first prompt will be for the database you wish to work with. Type the name of the file, or press Enter on an empty prompt to bring up a window of all databases in the current directory for selection. ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │INVEND.DBF │ 259 │ 09/16/89 │ │INVENT.DBF │ 375 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SOMEDAY.DBF │ 7335 │ 09/16/89 │ │TANGO.DBF │ 103 │ 09/16/89 │ │AP.DBF │ 24387 │ 09/17/89 │ │BACKUP.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌──────────────────────────────────────────│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ │ └────────────────────────┘ └───────────────────────────────────────────────────────────────┘ DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 74 The next prompt is for a condition or filter. This makes it possible to list only specific records that meet that condition you enter. The condition must be a valid dBase/Clipper expression, or none (to list all). ╒╔══════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌─────────────────────────────────────────────────────┐ │ Enter Filter: │ │ IE: ID = "SAM0909" .AND. RETAIL > 10000 │ └─────────────────────────────────────────────────────┘ ┌───────────────────────────────────────────────────────────────┐ │ Enter Database Name: │ │ │ └───────────────────────────────────────────────────────────────┘ A window box appears next displaying all the fields in the selected database and an option to list all fields. Highlight any combination of fields ( or ALL) that you want listed. ╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ │ PICK THE FIELDS │ ║ ╘║P│ YOU WANT LISTED │} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║ ├─────────────────┤ ║ ╚═│■■ ALL ■■ │═══════════════════════════════════════════════════════╝ │RECNO() │ │MFG_PART │ │PRICE │ │YOURPART │ ┌────────────────────────────────────────────────────┐ │NOTES │ │ Enter Filter: │ ├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │ │PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘ └─────────────────┘────────────────────────────────────────────────────┐ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 75 The fields you select will be displayed at center top of screen. Press Esc to exit the "PICK THE FIELDS YOU WANT LISTED" window. ╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ │ PICK THE FIELDS │ ║ ╘║P│ YOU WANT LISTED │} ■ DES┌────────────────────┐{N} ■ YOURPART{C} ■ ║ ║N├─────────────────┤ │PART │ ║ ╚═│■■ ALL ■■ │═══════│MFG_PART │══════════════════════════╝ │RECNO() │ │PRICE │ │PART │ └────────────────────┘ │PRICE │ │YOURPART │ ┌────────────────────────────────────────────────────┐ │NOTES │ │ Enter Filter: │ ├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │ │PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘ └─────────────────┘────────────────────────────────────────────────────┐ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ At the next prompt, you can send the list to the SCREEN, PRINTER OR FILE. ╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ │ PICK THE FIELDS │ ║ ╘║P│ YOU WANT LISTED │} ■ DES┌────────────────────┐{N} ■ YOURPART{C} ■ ║ ║N├─────────────────┤ │PART │ ║ ╚═│■■ ALL ■■ │═══════│MFG_PART │══════════════════════════╝ │RECNO() │ │PRICE │ │PART │ └────────────────────┘ │DESC┌──────────────────────────────────────────────────────────────────┐ │PRIC│ Do you want to print the list to the SCREEN or PAPER or FILE ? │ │LIST│ │ │YOUR└──────────────────────────────────────────────────────────────────┘─┐ │NOTES │ │ Enter Filter: │ ├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │ │PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘ └─────────────────┘────────────────────────────────────────────────────┐ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 76 The list is very simple, and if displayed onto the screen, may look like the following: PART MFG_PART PRICE 4523 0.00 DAYO9S 41926 1904.34 DAYO10S 13564 616.11 DAYOCOMP 45625 2072.37 DAYOALLS 43159 1960.35 INDEXER 50558 2296.41 INDEXERS 51791 2352.42 5 DEMO 4932 224.04 DAYO13S 20963 952.17 MENUS 53024 2408.43 OFFSITEP 56724 2576.46 ONSITEP 57957 2632.47 DAYO2S 24662 1120.20 DAYO9 40693 1848.33 DAYO10 12331 560.10 DAYOCAL$ 44392 2016.36 DAYO13 19730 896.16 DAYO2 23429 1064.19 DAYO11 14797 672.12 DAYO8 38227 1736.31 DAYO1 11098 504.09 DAYO12 17264 784.14 DAYO5 30828 1400.25 ......PRESS ANY KEY TO CONTINUE...... ■ MODIFY DATABASE Change the fields/structure of a database. You can add new fields, delete fields, change the length and type of field in any of the databases. At the FIELD_NAME field, enter a unique field name. At the FIELD_TYPE field, enter a 'C' for character, 'N' for numeric, 'D' for Date, 'L' for logical or 'M' for memofield. At the FIELD_LEN field, enter the size/length of the character and/or numeric field. At the FIELD_DEC field, enter the number of decimals for the numeric field. ******************************************************** *** TO EDIT ANY FIELD, YOU MUST PRESS Enter FIRST *** *** IT IS SLIGHTLY BOTHERSOME SORRY! *** ******************************************************** *** If any error is made in this routine, you will experience an error, either immediately, or when you start to access the database. This error may even cause your computer to hang! DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 77 *** Be sure to Press: Ctrl W when you are finished and satisfied. Pressing Esc will just negate your efforts.. ■ PACK DATABASE Pack a database (removed deleted records). This option will permanently remove any records marked for deletion. This is another routine you should use with great care! As in many of the other of the routines, you will be prompted to enter the name of the database you wish to pack. Enter the name or press Enter on an empty prompt to view the window. ┌─────┐ │PACK!│ └─────┘ ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │GOODDATA.DBF │ 259 │ 09/16/89 │ │HAP.DBF │ 375 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SDF.DBF │ 7335 │ 09/16/89 │ │LOIN.DBF │ 103 │ 09/16/89 │ │TRASH.DBF │ 24387 │ 09/17/89 │ │FIX.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌──────────────────────────────────────────│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ └──────────────────────────────────────────└────────────────────────┘ After selecting the database, you will be prompted to respond with a Yes or No (to Pack or not to Pack...). This is the last chance you have to change your mind... ┌──────────────────────────────────────────────────────────────────────────┐ │ PACK TOM3 │ │ Are you sure you want to PACK (remove deleted records) ? N │ └──────────────────────────────────────────────────────────────────────────┘ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 78 ■ RECALL RECORDS Recalls records previously marked for deletion. This option is identical to the DELETE RECORDS option discussed earlier... ■ RETURN TO MENU Returns to the procedure that called MISC Routines. ■ RUN (DOS COMMAND) Run a DOS command (EG: dir/w). This option is helpful in that it allows you to run programs at the DOS level (within memory constraints). ┌───────────────────────────────────────────────────────────────────────────┐ │ RUN CD\DOS │ └───────────────────────────────────────────────────────────────────────────┘ One useful option is to type and Enter: COMMAND at this prompt. You will be running another DOS Shell totally out of the program (it still is in memory though). ┌───────────────────────────────────────────────────────────────────────────┐ │ RUN COMMAND │ └───────────────────────────────────────────────────────────────────────────┘ Press and Enter: EXIT to return to your Clipper Application. DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 79 ■ SIMPLE EDITOR A simple editor and word processor. Use this option to create and read simple TEXT files. File size is limited to your machines capabilities or 32,000k. The first prompt is for the name of the file you wish to edit. Type in the name, or press Enter on an empty prompt to bring up a window option box containing all files in the current directory. ┌────────────────────────┐ ┌──────────[ EDIT THE FILE ]───────────┐ │ Highlight a file │ │ FILE NAME SIZE DATE USED│ │ using the │ ├──────────────┬────────────┬──────────┤ │ arrow keys, then press │ │B.BAT │ 222 │ 09/16/89 │ │ Enter/Return. │ │BKDOOR.DOC │ 56356 │ 09/17/89 │ └────────────────────────┘ │BKDOOR.ZIP │ 19415 │ 09/16/89 │ │DAYOBK.LIB │ 36879 │ 09/16/89 │ │DAYOBK.LST │ 2056 │ 09/16/89 │ ┌────────│DAYOBK.OBJ │ 35585 │ 09/16/89 │────────────────────────────┐ │ Enter t│DAYOCAL.MAP │ 35 │ 09/16/89 │ │ │ Press E│DDD.DBF │ 375 │ 09/16/89 │urrent directory listing. │ └────────│DDD.DBT │ 512 │ 09/16/89 │────────────────────────────┘ │DDD.NTX │ 2048 │ 09/16/89 │ │DEMO.EXE │ 245404 │ 09/16/89 │ │DEMO.MAP │ 7780 │ 09/16/89 │ └──────────────┴────────────┴──────────┘ More *** Note, this routine will try to load binary files (.EXE, .OBJ, .etc...), so be careful at what you select for viewing/editing. If you make ANY changes to the file, You MUST PRESS Ctrl W to SAVE those changes. If you exit with an Esc, all changes will be lost! ┌──────────────────────────────[ SIMPLE EDITOR ]─────────────────────────────┐ │CLIPPER demo │ │CLIPPER MISC │ │KWAIT 10 │ │LIB MISC-+MISC,MISC.LST,MISC │ │KWAIT 10 │ │TLINK DEMO,,,MISC \CLIPPER\CLIPPER \CLIPPER\EXTEND │ │KWAIT 10 │ │DEMO │ └────────────────────────────────────────────────────────────────────────────┘ Esc (ABORT) Ctrl W (SAVE) Initial Size: 222 1/0 DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 80 Special keys for 'moving around' the SIMPLE EDITOR screen are: Left Arrow Key - Move to your left Right Arrow Key - Move to your right Ctrl Home - Go to the top, leftmost corner of window Ctrl End - Go to the bottom, rightmost corner of window Up Arrow - Move up one line Down Arrow - Move down one line PgUp - Page up a full screen PgDn - Page down a full screen Ctrl PgUp - Go to the beginning of the file Ctrl PgDn - Go to the end of the file * F2 - Import text from a text file * Ctrl W - Save Changes and Exit * Esc - ABORT Changes and Exit The margin may exceed the boundaries on the right side of the screen, but the text is easily accessed using the special keys above... ■ SORT DATABASE This option takes a database, sorts it, and copies the result into a new database. The first prompt is for the name of the database you want to sort. Enter the name, or press Enter on an empty prompt to bring up a window box containing all databases in the current directory. ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │DOG.DBF │ 259 │ 09/16/89 │ │CAT.DBF │ 375 │ 09/16/89 │ │CAR.DBF │ 195 │ 09/17/89 │ │BAM.DBF │ 7335 │ 09/16/89 │ │HARP.DBF │ 103 │ 09/17/89 │ │TRAIN.DBF │ 24387 │ 09/17/89 │ │HIPPY.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌───────────────────[ SORT A DATABASE ]────│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ │ └────────────────────────┘ │ │ └───────────────────────────────────────────────────────────────┘ DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 81 The next prompt is for the name of the database you will be creating with the sorted data. ╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ SORT A DATABASE ]─────────────────────────┐ │ Enter Database Name: INVNET.DBF │ │ Enter Name of Sorted File: INVNET1.DBF │ │ │ └───────────────────────────────────────────────────────────────┘ The next prompt is for the sort field (limited to 1 field)... ╒╔═════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚══════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ SORT A DATABASE ]─────────────────────────┐ │ Enter Database Name: TOM.DBF │ │ Enter Name of Sorted File: TOM1.DBF │ │ Enter the Key Expression: PART │ └───────────────────────────────────────────────────────────────┘ ■ TYPE (PRINT) FILE Prints an ASCII/text file to screen or printer. The first prompt is for the file name. ┌───────────────────────[ TYPE TO SCREEN OR PRINTER ]────────────────────────┐ │ Enter the ASCII/TEXT file to TYPE: KISBBS.DOC │ │ Press Enter/Return on an empty field to get a current directory listing. │ └────────────────────────────────────────────────────────────────────────────┘ DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 82 The display of the file (any type), is continuous, but can be paused by any key (except the Enter & Esc keys). Pressing the Enter key will slow the printing of the file onto the screen. Press Esc to Abort the display... A sample display: FUNCKEY...........MISC FUNIQUE...........MISC FZAP..............MISC GET_PIC1..........MISC ISDATA............MISC ISDBF.............MISC MENU_KEY..........MISC MISC..............MISC OKFILE............MISC PACKIT............MISC PICKDBF...........MISC PROCLIST..........MISC SHOW_INS2.........MISC STATLINE2.........MISC TOG_INS2..........MISC XKEY_CLEAR........MISC XKEY_NORM.........MISC XMEMO.............MISC MISC BKDOOR BROWSEIT CENTER1 COLORSET DBFUNCT DBFUNCT6 EDITOR FACHOICE FAPPEND FCOPY2 FDBF1 FDELETE FERASE FILESZ FILE_UDF FILT FINDER FINDEX FMAKEDB FMODYDB FNEW FRECALL FRUN FSCROLL1 FSORT FTYPEIT FUNCKEY FUNIQUE FZAP GET_PIC1 ISDATA ISDBF MENU_KEY MISC OKFILE PACKIT PICKDBF PROCLIST SHOW_INS2 STATLINE2 TOG_INS2 XKEY_CLEAR XKEY_NORM XMEMO PRESS ANY KEY TO CONTINUE... ■ ZAP DATABASE Totally erase all records in database (forever!). When you want to remove every record from a database, then use this option. Use with EXTREME CAUTION! The first prompt is for the file name. Enter the name of the database you are to 'clean out', or press Enter to select the database from a window containing all databases in the current directory. DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 83 ┌────┐ │ZAP!│ └────┘ ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │DENVER.DBF │ 259 │ 09/16/89 │ │OHIO.DBF │ 375 │ 09/16/89 │ │NEWYORK.DBF │ 195 │ 09/17/89 │ │MONTANA.DBF │ 7335 │ 09/16/89 │ │SC.DBF │ 259 │ 09/17/89 │ │EARS.DBF │ 103 │ 09/17/89 │ │FRUIT.DBF │ 24387 │ 09/17/89 │ ┌────────────────────────┐ │MATH.DBF │ 259 │ 09/17/89 │ │ Highlight a database │ │CARROTS.DBF │ 289 │ 09/16/89 │ │ using the │ └──────────────┴────────────┴──────────┘───│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ └──────────────────────────────────────────└────────────────────────┘ You will be prompted one last time as to whether you still want to ZAP the selected database. Press Y for Yes, N for No... ┌────┐ │ZAP!│ └────┘ ┌──────────────────────────────────────────────────────────────────────────┐ │ ZAP TRASH │ │ Are you sure you want to ZAP (remove all records permanently) ? N │ │ │ └──────────────────────────────────────────────────────────────────────────┘ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 84 ■ SCREEN FONTS This option allows EGA or VGA capable computers to set a global font for use while in the program. Defaults to standard font. ╔═══[ SCREEN FONTS ]═════════════════════════════╗ ║ ║ ║ Select Font -> Standard (Normal) ║ ║ Old English ║ ║ Avante Garde ║ ║ Bauhaus ║ ║ Bodoni ║ ║ Esc (Exit) Broadway ║ ║ Script I ║ ║ Script II ║ ║ Calligraphy ║ ║ Garamond ║ ║ Legend ║ ║ Percy ║ ║ Park Avenue ║ ╚════════════════════════════════════════════════╝ ■ SYSTEM This routine lists system statistics about your computer and optionally lets you set the date and time. ╔═════════════════════════════════[ SYSTEM ]═════════════════════════════════╗ ║ DOS Version: 3.310 ║ ║ DOS Memory: 640 ║ ║ Free DOS Memory: 48 ║ ║ Extended Memory: 0 ║ ║ Expanded Memory: 0 ║ ║ Parallel Ports: LPT1: ║ ║ Serial Ports: COM1: COM2: ║ ║ CPU Type: 80386 ║ ║ Monitor Type: VGA ║ ║ Available Drives: ABCD ║ ║ Current Drive: D: ║ ║ Volume Name: ║ ║ Disk Size: 175,996,928 ║ ║ Available Space: 13,254,656 7.53% of Disk Open... ║ ║ Disk Clusters: 21,484 ║ ║ Cluster Size: 8,192 ║ ║ Sectors: 16 ║ ║ Sector Size: 512 ║ ║ Date: 10/29/91 ║ ║ Time: 00:44:30 ║ ║ Change Date and/or Time? (Y/N) ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 85 ■ REPORT PRINTER PORT This is the printer port that all your reports will be directed to when printing to a printer. The default is LPT1. ╔══════════════════════════[ REPORT PRINTER PORT ]═══════════════════════════╗ ║ Enter Your Report Printer Port (1,2,3): 1 ║ ╚════════════════════════════════════════════════════════════════════════════╝ ■ AUTOMATIC DAILY INDEXING Though not required, it is usually a good idea to reindex all databases at the beginning of each day. Indexes can easily be corrupted by power failures and using the MISC routines to add, delete, zap or pack databases. ╔════════════════════════[ AUTOMATIC DAILY INDEXING ]════════════════════════╗ ║ If this option is set to Y (YES), then all DAYO Indexes accessed by ║ ║ DAYO SC will be recreated once daily. This will occur when the first ║ ║ DAYO SC program is run. The default is to recreate all the indexes daily. ║ ║ ║ ║ Recreate all DAYO SC Indexes? (Y/N) ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ ■ COLOR MONITOR If you have a color monitor (the default setting), then set this option to Y (Yes). ╔═════════════════════════════[ COLOR MONITOR ]══════════════════════════════╗ ║ If you have a color monitor and wish to display colors, then select Y, ║ ║ (YES), else select N (NO) for monochrome and others. ║ ║ The default is color, low intensity ║ ║ ║ ║ Do you have a color monitor? (Y/N) ║ ╚════════════════════════════════════════════════════════════════════════════╝ ■ COLOR INTENSITY If you want high intensity colors, then set this option to Y (Yes). ╔════════════════════════════[ COLOR INTENSITY ]═════════════════════════════╗ ║ Intensity is only applicable with color set to Y. ║ ║ It will make your colors brighter... ║ ║ ║ ║ Set Color Intensity On? (Y/N) ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 86 ■ CREDITS This routine simply displays information about who created DAYO SC... ╔══════════════════[ CREDITS ]════════════════════╗ ║ DAYO Support Calls Management System ║ ║ Copyright (c) 1992 ║ ║ TJS LAB, Inc. ║ ║ 5104 North Orange Blossom Trail, #200 ║ ║ Orlando, Florida 32810 ║ ║ ║ ║ Voice: (407) 292-4708 or 291-3960 ║ ║ Fax: (407) 295-2171 ║ ║ Modem: (407) 292-4921 (2400-8-N-1) ║ ║ ║ ║ Written Originally for Software Support, Inc. ║ ║ Lake Mary, Florida ║ ║ ║ ║ Author: Tom Johnson ║ ║ Publisher: Lorraine Turner ║ ║ Testers: Paul Turner and Darren Kelly ║ ╚═════════════════════════════════════════════════╝ DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 87 ■ REINDEX ALL DATABASES A complete reindex can be accomplished from the main menu by pressing Alt F9. Use this option whenever you suspect a bad/corrupted index. Indexes can easily be corrupted by power failures and using the MISC routines to add, delete, zap or pack databases. ┌──────────────────────────────────────────────────────────┐ │ Database Name: PIN.DBF │ │ Index Name: PIN.NTX │ │ Index Key: PIN │ │ Number of Records: 161 │ │ ┌──────────────────────────────────────────────────┐ │ │ │████████████████████████ │ │ │ └──────────────────────────────────────────────────┘ │ │ 0 ─ 10 ─ 20 ─ 30 ─ 40 ─ 50 ─ 60 ─ 70 ─ 80 ─ 90 ─ 100 % │ └──────────────────────────────────────────────────────────┘ ■ AVAILABLE MEMORY Since this is a big program and requires at least 530k free memory before startup, this routine was incorporated to help you monitor your memory (RAM). Accessed from any point in the program by pressing Alt F10... ╔═══════════════════════════════════════╗ ║ Available Memory: 55 ║ ║ Largest Memory Block: 29 ║ ║ Available RUN Memory: 28 ║ ╚═══════════════════════════════════════╝ DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 88 ■ HELP SCREENS While in the browse screens, some of the option windows, and in the SIMPLE EDITOR, pressing the F1 key, will display a help screen. BROWSE help: ┌───────────────────────[ DAYOSC HELP: DBEDIT, 0, ]─────────────────────────┐ │ │ │- Special keys for 'moving around' the BROWSE screen are: │ │ │ │ Left Arrow Key - Move to next field to your left │ │ Right Arrow Key - Move to next field to your right │ │ Ctrl Home - Go to the leftmost field │ │ Ctrl End - Go to the rightmost field (on the end of the record)│ │ Up Arrow - Move highlight to the previous record │ │ Down Arrow - Move highlight to the next record │ │ PgUp - Page up a full screen of records │ │ PgDn - Page down a full screen of records │ │ Ctrl PgUp - Go to the beginning of the file │ │ Ctrl PgDn - Go to the end or last record of the file │ │ Ctrl N - Add a record (where applicable) │ │ Ctrl U - Delete a record (where applicable) │ │ F5,F6,F7 - To seek/find a record based upon the active index │ │ Esc - Exit the current operation │ │ │ │ Remember that there are many more fields to the right of the screen. │ │ Press the right arrow key to view them... │ └────────────────────────────────────────────────────────────────────────────┘ Option Box Help: ┌────────────────────────[ DAYOSC HELP: ACHOICE, 0, ]───────────────────────┐ │ │ │ │ │ │ │ │ │ - Special keys for 'moving around' the Option Box are: │ │ │ │ Up Arrow - Move up one option │ │ Down Arrow - Move down one option │ │ PgUp - Page up multiple records │ │ PgDn - Page down multiple records │ │ Esc - ABORT and Exit │ │ │ │ │ │ After highlighting the option you desire, press Enter... │ │ │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 89 Editor help: ┌───────────────────────[ DAYOSC HELP: MEMOEDIT, 0, ]───────────────────────┐ │ │ │ - Special keys for 'moving around' the EDITOR screen are: │ │ │ │ Left Arrow Key - Move to your left │ │ Right Arrow Key - Move to your right │ │ Ctrl Home - Go to the top, leftmost corner of window │ │ Ctrl End - Go to the bottom, rightmost corner of window │ │ Up Arrow - Move up one line │ │ Down Arrow - Move down one line │ │ PgUp - Page up a full screen │ │ PgDn - Page down a full screen │ │ Ctrl PgUp - Go to the beginning of the file │ │ Ctrl PgDn - Go to the end of the file │ │ Ctrl W - SAVE Changes and Exit │ │ Esc - ABORT Changes and Exit │ │ F2 - Import another text file into your document │ │ │ │ The margin may exceed the boundaries on the right side of the screen, │ │ but the text is easily accessed using the special keys above... │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ ■ EXPANDED HELP After Version 1.3, expanded help routines were added to all DAYO modules. At almost all prompts and menus you can press F1 for help. Help can be a function key message as displayed on previous page, a message that you have created (user defined & inputted), or the ability to read the documentation on the screen (saves paper). DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 90 ■ USER DEFINED & INPUTTED HELP SCREENS/MESSAGES If you press F1 and no user defined & inputted message exists for that section of the program you are currently in you will receive a message to this effect, and then a blank/empty screen. The editing keys for this option are the same as for the Simple Editor (previous page). ┌──────[ DAYO HELP Called by Program: DAYOSC Variable: OPT ]───────┐ │ │ │ │ │ │ │ │ │ │ │ │ │ ╔════════════════════════════════════════════════════════╗ │ │ ║ No Online Help Messages Exist for this prompt... ║ │ │ ║ ║ │ │ ║ You can type in any help message you wish, or ║ │ │ ║ press F1 to view the document for DAYOSC. ║ │ │ ║ ║ │ │ ║ ║ │ │ ║ Press any key to continue... ║ │ │ ╚════════════════════════════════════════════════════════╝ │ │ │ │ │ ├───────────────────────────────────────────────────────────────────────────┤ │ Esc (Exit) Ctrl W (Save Changes) F1 (Read Manual) │ └───────────────────────────────────────────────────────────────────────────┘ If you wish to input anything at this point, just type whatever you wish, remembering to press Ctrl W to save all changes. Pressing Esc will not save ANY changes ( all effort you put into writing a help message will be lost! ). DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 91 ┌───────[ DAYO HELP Called by Program: DAYOSC Variable: OPT ]───────┐ │ │ │ │ │ │ │ Type in anything you wish about this portion of the program! │ │ │ │ The length of this file can be many pages... │ │ │ │ Be sure to press Ctrl W to save any changes/additions you make to this │ │ screen. │ │ │ │ │ │ │ │ │ │ │ │ │ ├────────────────────────────────────────────────────────────────────────────┤ │ Esc (Exit) Ctrl W (Save Changes) F1 (Read Manual) 13/4 │ └────────────────────────────────────────────────────────────────────────────┘ ■ VIEW DOCUMENTATION ON SCREEN To view the documentation for the module you are in, it must first exist in the current directory. Document files are named the same as the module, and have the extension of '.DOC', ie: DAYOSC.DOC, DAYOPOS.DOC, DAYOPAY.DOC. Press F1 in the User Defined & Inputted Help Message screen to display the document (user manual). The special keys in this option are displayed in the Help Screen (press F1 again) for this option: ╔══════════════════════════════════════════════════════════════════════════╗ ║ While viewing the document for DAYO SC the keyboard is configured ║ ║ as followed: ║ ║ ║ ║ Esc Exit ║ ║ F5 Find a string. This search is not case sensitive ║ ║ Examples: Page 50 ║ ║ INTRODUCTION ║ ║ REPORTS ║ ║ Home Return to the beginning of the document ║ ║ End Go to the bottom of the document ║ ║ PgUp Page up ║ ║ ║ ║ Any other key moves acts like PgDn (page down) ║ ║ ║ ║ Press any key to continue... ║ ╚══════════════════════════════════════════════════════════════════════════╝ DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 92 ■ DATABASE STRUCTURES Structure for database: CALLOG.CFG Field Field name Type Width Dec ───── ────────── ───────── ───── ─── 1 PASSWORD Character 7 2 LOGIN Character 30 3 NAME Character 30 4 DATE Date 8 5 ACTIVE Logical 1 6 SDATE Date 8 7 STIME Character 8 8 STATUS Logical 1 9 EXCLUDE Character 15 ────────── ───── Total 109 Structure for database: CAT1.DBF 1 CATEGORY Character 39 ────────── ───── Total 40 Structure for database: CAT2.DBF Field Field name Type Width Dec ───── ────────── ───────── ───── ─── 1 CATEGORY Character 39 ────────── ───── Total 40 DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 93 Structure for database: CODES.CFG Field Field name Type Width Dec ───── ────────── ───────── ───── ─── 1 CODE_0 Character 1 2 CODE_1 Character 1 3 CODE_2 Character 1 4 CODE_3 Character 1 5 CODE_4 Character 1 6 CODE_5 Character 1 7 CODE_6 Character 1 8 CODE_7 Character 1 9 CODE_8 Character 1 10 CODE_9 Character 1 ────────── ───── Total 11 Structure for database: CUSTMEMO.DBF Field Field name Type Width Dec ───── ────────── ───────── ───── ─── 1 CUSTOMER Numeric 6 2 NOTES Memo 10 ────────── ───── Total 17 DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 94 Structure for database: CUSTOMER.DBF Field Field name Type Width Dec ───── ────────── ───────── ───── ─── 1 CUSTOMER Numeric 6 2 NAME Character 30 3 ATTN Character 30 4 ADDR1 Character 30 5 ADDR2 Character 30 6 CITY Character 22 7 STATE Character 2 8 ZIP Character 10 9 PHONE Character 14 10 SHIPNAME Character 30 11 SHIPADDR1 Character 30 12 SHIPADDR2 Character 30 13 SHIPCITY Character 22 14 SHIPSTATE Character 2 15 SHIPZIP Character 10 16 SHIPPHONE Character 14 17 SALESPER Character 3 18 TAXRATE Numeric 7 5 19 TAXRATE2 Numeric 7 5 20 TERMS Character 20 21 SHIPPER Character 20 22 FOB Character 20 23 DATE Date 8 24 LASTDATE Date 8 25 TYPE Character 3 26 CLASS Character 3 27 PBM Numeric 6 3 28 PBL Numeric 6 3 29 SALESPTD Numeric 10 2 30 SALESYTD Numeric 10 2 31 DUE Numeric 10 2 32 PAID_PURC Numeric 10 2 33 LIMIT Numeric 10 2 34 FAX Character 14 35 PRICEX Numeric 1 36 ACTIVE Logical 1 37 CREDCARD Character 20 38 TAXCODE Character 3 ────────── ───── Total 513 DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 95 Structure for database: DAYOCUST.CFG Field Field name Type Width Dec ───── ────────── ───────── ───── ─── 1 CUSTOMER Numeric 6 ────────── ───── Total 7 Structure for database: HISTORY.DBF Field Field name Type Width Dec ───── ────────── ───────── ───── ─── 1 REFERENCE Numeric 8 2 PIN Character 11 3 CUSTOMER Numeric 6 4 CATEGORY1 Character 30 5 CATEGORY2 Character 30 6 RESOLUTION Character 30 7 COMMENTS Character 50 8 PHONE Character 20 9 DATE Date 8 10 TIME Character 8 11 ENDDATE Date 8 12 ENDTIME Character 8 13 TECHNICIAN Character 30 14 CLOSEDBY Character 30 15 OPEN Logical 1 16 NOTES Memo 10 ────────── ───── Total 289 Structure for database: INCIDENT.DBF Field Field name Type Width Dec ───── ────────── ───────── ───── ─── 1 REFERENCE Numeric 8 2 PIN Character 11 3 CUSTOMER Numeric 6 4 CATEGORY1 Character 30 5 CATEGORY2 Character 30 6 RESOLUTION Character 30 7 COMMENTS Character 50 8 PHONE Character 20 9 DATE Date 8 10 TIME Character 8 11 ENDDATE Date 8 12 ENDTIME Character 8 13 TECHNICIAN Character 30 14 CLOSEDBY Character 30 15 OPEN Logical 1 16 NOTES Memo 10 ────────── ───── Total 289 DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 96 Structure for database: LOG.DBF Field Field name Type Width Dec ───── ────────── ───────── ───── ─── 1 PIN Character 11 2 CATEGORY1 Character 30 3 CATEGORY2 Character 30 4 PHONE Character 20 5 DATE Date 8 6 TIME Character 8 7 CLOSED Logical 1 ────────── ───── Total 109 Structure for database: MENU.DBF Field Field name Type Width Dec ───── ────────── ───────── ───── ─── 1 FILENAME Character 12 2 DESC Character 30 3 LASTDATE Date 8 4 LASTTIME Character 8 5 RUNS Numeric 7 6 LOCATION Character 60 7 DATE Date 8 8 LASTUSER Character 30 ────────── ───── Total 164 DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 97 Structure for database: PDRIVER.DBF Field Field name Type Width Dec ───── ────────── ───────── ───── ─── 1 NAME Character 30 2 LINEFEED Character 30 3 NORMAL Character 50 4 SMALL Character 50 5 BOLDON Character 50 6 BOLDOFF Character 50 7 _6LPI Character 50 8 _8LPI Character 50 9 PORTRAIT Character 50 10 LANDSCAPE Character 50 11 RESET Character 50 12 SPEC_STR1 Character 50 13 SPEC_STR2 Character 50 14 SPEC_STR3 Character 50 15 SPEC_STR4 Character 50 16 SPEC_STR5 Character 50 17 RUN_CMD Character 50 ────────── ───── Total 811 Structure for database: PIN.DBF Field Field name Type Width Dec ───── ────────── ───────── ───── ─── 1 PIN Character 11 2 CUSTOMER Numeric 6 3 FNAME Character 15 4 LNAME Character 15 5 ADDRESS1 Character 30 6 ADDRESS2 Character 30 7 CITY Character 22 8 STATE Character 2 9 ZIP Character 10 10 PHONE1 Character 20 11 PHONE2 Character 20 12 DOB Date 8 13 SSN Character 11 14 DATE Date 8 15 TIME Character 8 16 ENDDATE Date 8 17 CALLS Numeric 5 18 LASTCAT1 Character 30 19 LASTCAT2 Character 30 20 LASTRESOLU Character 30 21 LASTDATE Date 8 22 LASTTIME Character 8 ────────── ───── Total 336 DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 98 Structure for database: PINMEMO.DBF Field Field name Type Width Dec ───── ────────── ───────── ───── ─── 1 PIN Character 11 2 NOTES Memo 10 ────────── ───── Total 22 Structure for database: REFER.CFG Field Field name Type Width Dec ───── ────────── ───────── ───── ─── 1 REFERENCE Numeric 8 ────────── ───── Total 9 Structure for database: RESOLUTE.DBF Field Field name Type Width Dec ───── ────────── ───────── ───── ─── 1 RESOLUTION Character 30 ────────── ───── Total 31 DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 99 ■ DATA DICTIONARY Field Name Type Len Dec Database Description/Comments ────────── ──── ─── ─── ──────────── ────────────────────────────────── ACTIVE L 1 0 CALLOG.CFG Flag field to designate password or user as being active or not CUSTOMER.DBF Flag field to designate customer as being active or not. Not used by DAYO SC ADDR1 C 30 0 CUSTOMER.DBF Line 1 of the customer's address ADDR2 C 30 0 CUSTOMER.DBF Line 2 of the customer's address ADDRESS1 C 30 0 PIN.DBF Line 1 of the PIN/Customer's address ADDRESS2 C 30 0 PIN.DBF Line 2 of the PIN/Customer's address ATTN C 30 0 CUSTOMER.DBF Contact or Attention name BOLDOFF C 50 0 PDRIVER.DBF Printer code that sets up printer to turn off BOLD BOLDON C 50 0 PDRIVER.DBF Printer code that sets up printer to turn on BOLD CALLS N 5 0 PIN.DBF Number of support calls/incidents logged by the PIN/Customer CATEGORY C 39 0 CAT2.DBF Category/Problem code CAT1.DBF CATEGORY1 C 30 0 LOG.DBF 1st category/problem code INCIDENT.DBF HISTORY.DBF CATEGORY2 C 30 0 INCIDENT.DBF 2nd category/problem code HISTORY.DBF LOG.DBF CITY C 22 0 PIN.DBF City address CUSTOMER.DBF CLASS C 3 0 CUSTOMER.DBF Class code field, not used by DAYO SC CLOSED L 1 0 LOG.DBF Flag field that designated VRU database record as being moved into the OPEN database or not CLOSEDBY C 30 0 INCIDENT.DBF Name of user/technician that HISTORY.DBF closed the call/incident record CODE_0 C 1 0 CODES.CFG Serial number conversion of '0' CODE_1 C 1 0 CODES.CFG Serial number conversion of '1' CODE_2 C 1 0 CODES.CFG Serial number conversion of '2' CODE_3 C 1 0 CODES.CFG Serial number conversion of '3' CODE_4 C 1 0 CODES.CFG Serial number conversion of '4' CODE_5 C 1 0 CODES.CFG Serial number conversion of '5' CODE_6 C 1 0 CODES.CFG Serial number conversion of '6' CODE_7 C 1 0 CODES.CFG Serial number conversion of '7' CODE_8 C 1 0 CODES.CFG Serial number conversion of '8' CODE_9 C 1 0 CODES.CFG Serial number conversion of '9' DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 100 Field Name Type Len Dec Database Description/Comments ────────── ──── ─── ─── ──────────── ────────────────────────────────── COMMENTS C 50 0 HISTORY.DBF Comments/brief note about the INCIDENT.DBF support call/incident CREDCARD C 20 0 CUSTOMER.DBF Credit card number, not used by DAYO SC CUSTOMER N 6 0 CUSTOMER.DBF Customer number PIN.DBF DAYOCUST.CFG CUSTMEMO.DBF HISTORY.DBF INCIDENT.DBF DATE D 8 0 CUSTOMER.DBF Date record was created LOG.DBF INCIDENT.DBF HISTORY.DBF PIN.DBF MENU.DBF CALLOG.CFG DESC C 30 0 MENU.DBF Description of an external program DOB D 8 0 PIN.DBF Date of birth of PIN/Customer DUE N 10 2 CUSTOMER.DBF Amount due by the customer, not used by DAYO SC ENDDATE D 8 0 HISTORY.DBF Date that call/incident was closed INCIDENT.DBF PIN.DBF Date that support contract ends ENDTIME C 8 0 HISTORY.DBF Time that call/incident was closed INCIDENT.DBF EXCLUDE C 15 0 CALLOG.CFG Field contains the excluded main menu options. Used with passwords FAX C 14 0 CUSTOMER.DBF Customer's FAX number FILENAME C 12 0 MENU.DBF File name of external menu option FNAME C 15 0 PIN.DBF First name FOB C 20 0 CUSTOMER.DBF Freight on board code/description LANDSCAPE C 50 0 PDRIVER.DBF Printer code that sets up an HP Laser printer to print sideways LASTCAT1 C 30 0 PIN.DBF Last 1st category/problem that a PIN had LASTCAT2 C 30 0 PIN.DBF Last 2nd category/problem that a PIN had LASTDATE D 8 0 PIN.DBF Last date a PIN had a problem MENU.DBF Last date an external program was run CUSTOMER.DBF Last date accounting accessed the customer record LASTRESOLU C 30 0 PIN.DBF Last resolution code that a PIN had LASTTIME C 8 0 PIN.DBF Last time a PIN had a problem MENU.DBF Last time an external program was run DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 101 Field Name Type Len Dec Database Description/Comments ────────── ──── ─── ─── ──────────── ────────────────────────────────── LASTUSER C 30 0 MENU.DBF Last user/technician to run an external program LIMIT N 10 2 CUSTOMER.DBF Customer credit limit, not used by DAYO SC LINEFEED C 30 0 PDRIVER.DBF Printer code that prints a single line feed LNAME C 15 0 PIN.DBF Last name LOCATION C 60 0 MENU.DBF Location/Drive/Directory of an external program LOGIN C 30 0 CALLOG.CFG Login name of user/technician NAME C 30 0 CUSTOMER.DBF Customer/Company name CALLOG.CFG User/Techician name PDRIVER.DBF Name of printer NORMAL C 50 0 PDRIVER.DBF Printer code to print normal size (10 CPI) characters NOTES M 10 0 INCIDENT.DBF Call/Incident notes HISTORY.DBF CUSTMEMO.DBF Customer notes PINMEMO.DBF PIN notes OPEN L 1 0 HISTORY.DBF Flag field that designates a call INCIDENT.DBF or incident as being open or not PAID_PURC N 10 2 CUSTOMER.DBF Amount paid by a customer, not used by DAYO SC PASSWORD C 7 0 CALLOG.CFG Encrypted password PBL N 6 3 CUSTOMER.DBF N/A PBM N 6 3 CUSTOMER.DBF N/A PHONE C 20 0 LOG.DBF Telephone number HISTORY.DBF INCIDENT.DBF PHONE C 14 0 CUSTOMER.DBF Telephone number PHONE1 C 20 0 PIN.DBF PIN's 1st Telephone number PHONE2 C 20 0 PIN.DBF PIN's 2nd Telephone number PIN C 11 0 INCIDENT.DBF Personal Identification Number LOG.DBF PINMEMO.DBF HISTORY.DBF PIN.DBF PORTRAIT C 50 0 PDRIVER.DBF Printer code that make an HP Laser printer print upright (normal) PRICEX N 1 0 CUSTOMER.DBF N/A REFERENCE N 8 0 HISTORY.DBF Reference number of a support call INCIDENT.DBF or incident REFER.CFG RESET C 50 0 PDRIVER.DBF Printer code that resets the printer back to its default settings DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 102 Field Name Type Len Dec Database Description/Comments ────────── ──── ─── ─── ──────────── ────────────────────────────────── RESOLUTION C 30 0 RESOLUTE.DBF Resolution code. This is a code HISTORY.DBF that represents what you did to INCIDENT.DBF solve the problem RUNS N 7 0 MENU.DBF Number of times an external program was run/selected RUN_CMD C 50 0 PDRIVER.DBF Run a DOS command (ie: spool) while in the Printer Setup/Driver routine SALESPER C 3 0 CUSTOMER.DBF Sales person code assigned to the customer. Not used by DAYO SC SALESPTD N 10 2 CUSTOMER.DBF Customer sales period to date SALESYTD N 10 2 CUSTOMER.DBF Customer sales year to date SDATE D 8 0 CALLOG.CFG Start date that user/technician started running DAYO SC SHIPADDR1 C 30 0 CUSTOMER.DBF N/A SHIPADDR2 C 30 0 CUSTOMER.DBF N/A SHIPCITY C 22 0 CUSTOMER.DBF N/A SHIPNAME C 30 0 CUSTOMER.DBF N/A SHIPPER C 20 0 CUSTOMER.DBF N/A SHIPPHONE C 14 0 CUSTOMER.DBF N/A SHIPSTATE C 2 0 CUSTOMER.DBF N/A SHIPZIP C 10 0 CUSTOMER.DBF N/A SMALL C 50 0 PDRIVER.DBF Printer code that sets up printer to print small characters SPEC_STR1 C 50 0 PDRIVER.DBF Special/User defined printer code SPEC_STR2 C 50 0 PDRIVER.DBF Special/User defined printer code SPEC_STR3 C 50 0 PDRIVER.DBF Special/User defined printer code SPEC_STR4 C 50 0 PDRIVER.DBF Special/User defined printer code SPEC_STR5 C 50 0 PDRIVER.DBF Special/User defined printer code SSN C 11 0 PIN.DBF Social Security Number of PIN STATE C 2 0 PIN.DBF State address, ie: FL, CA, GA CUSTOMER.DBF STATUS L 1 0 CALLOG.CFG Flag field to designate whether a user/technician is currently in the program or not STIME C 8 0 CALLOG.CFG Start time that user/technician started running DAYO SC TAXCODE C 3 0 CUSTOMER.DBF N/A TAXRATE N 7 5 CUSTOMER.DBF N/A TAXRATE2 N 7 5 CUSTOMER.DBF N/A TECHNICIAN C 30 0 INCIDENT.DBF Name of your technician that HISTORY.DBF initiated the call/incident record TERMS C 20 0 CUSTOMER.DBF N/A TIME C 8 0 INCIDENT.DBF Time record was created HISTORY.DBF LOG.DBF PIN.DBF DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 103 Field Name Type Len Dec Database Description/Comments ────────── ──── ─── ─── ──────────── ────────────────────────────────── TYPE C 3 0 CUSTOMER.DBF N/A ZIP C 10 0 CUSTOMER.DBF Zip code PIN.DBF _6LPI C 50 0 PDRIVER.DBF Printer code that sets up printer to print 6 lines per inch (Usually the default) _8LPI C 50 0 PDRIVER.DBF Printer code that sets up printer to print 8 lines per inch DAYO SC, Copyright(c) 1992 TJS LAB, Inc. Page: 104 ■ TJS 'COMPUTER' LAB INC TJS LAB is an association of programmers and technicians that produce customized, multiuser software for the PC based network (ie: Novell and others). Our specialties include Inventory Control, PC Communications/EDI, Management, Reports (standard and graphic), Data Conversions, and Accounting (A/R, A/P). A unique feature of TJS LAB is that our software is by default, multiuser. 'Standalone' applications are the exception! All our applications are written in Clipper, Basic, or C (preferably Basic or Clipper). We will license all our application source codes. We produce applications that work, are easy to use, and are inexpensive! Want a change? Want an enhancement! Want a completely new product/application? Want to make your idea a reality? Custom/contract programming, by TJS LAB, and our associates is available. Standard rate is $50.00 per hour (our sites). Guaranteed quality and timely work is our number one policy. Write us at: TJS LAB PO Box 585366 Orlando, Florida 32858-5366 Or call us (9:00 am - 11:00 pm): (407) 291-3960 * Note that TJS LAB, nor any of the associates accept/take any support calls for unregistered products.